Permissions report, where to start?

Squiz Matrix General Discussion
1

Hi all,


I'm currently using a SQL query (in Toad, we're using Oracle) to find where a particular user or group has permissions assigned to assets.



Basically, select a user/group from SQ_AST_PERM, list all assets with perms assigned to that user and list the parent of each asset.



Is there a way to do this in Matrix?

2

Disregard. I've found the DB Data Source asset.