Specialized IT Services focused on Data Management | Speak with Us 877-634-9222
Art of BI: Oracle User Privileges Scan
I had been looking for a really quick way to diagnose the roles and privileges of users that I created in a test database.
I snagged this code snippet from the web sometime ago (Sorry, I know longer have the reference if any credit is due at all). I am posting it here mainly for my reference but perhaps it will help someone else as well.
lpad(‘ ‘, 2*level) || granted_role “User, his roles and privileges”
/* THE USERS */
username like upper(‘%&enter_username%’)
/* THE ROLES TO ROLES RELATIONS */
/* THE ROLES TO PRIVILEGE RELATIONS */
start with grantee is null
connect by grantee = prior granted_role;