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.
It’s 2015 and you can now establish totally respectable MS SQL DBA credibility just by mentioning you have been in the game since SQL Server version 9. You may even get the same gasps of shock from some colleagues that used to be reserved for the version 6 veterans.