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;
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 there are over one hundred logins in the source server and you need to migrate them all over to the destination server. Wouldn’t it be awesome if we could automate the process by generating the scripts for the required tasks?