Skip to main content
Question

How to create a report of users with security access?

  • May 17, 2022
  • 1 reply
  • 144 views
arebbeadle
Hero (Customer)
Forum|alt.badge.img+14

How to create a report of users with security access? I need a report that will show all active users that have access to >Solution Manager>Security objects. I can’t find the views I need to create an SQL statement for a quick report. Can someone help?

Thanks

 

1 reply

K
Superhero (Partner)
Forum|alt.badge.img+17
  • knepiosko
  • Superhero (Partner)
  • 514 replies
  • May 19, 2022

Hi @arebbeadle

 

Try this:

select * from activity_grant_tab
where activity_name like '%KeystoreAdmin%';

Piotr --> https://www.linkedin.com/in/piotr-skowronek-8425aa6/


Terms & ConditionsCookie settingsAccessibility statement