How to view all user permissions?

I've seriously looked, but this simple concept eludes me. How do I go about viewing all the permissions granted to a database user? Like whether or not they can execute a stored procedure.

Hi Xorcist,

To Query all the permissions granted to a user, you can query the sys.database_permissions table. It contains all the derived permission from role and explicitly granted permissions.

The Management Studio can only show the explicitly granted permissions. In this case, I suggest you query from that table.

For more information, please check

http://msdn2.microsoft.com/en-us/ms188367.aspx

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!