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;
Subscribe to Our Blog
Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.
EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.
Imagine over one hundred logins in the source server, you need to migrate them to the destination server. Wouldn’t it be awesome if we could automate the process?