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 some time ago (Sorry, I no 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.
Ultimately the goal of commentary in OBIEE is to have a system for persisting feedback, creating a call to action, and recognizing the prolific users.