I am working with permissions in SQL Server 2005/2008. I have created a role 'TestPerm' and assigned a test user to it. I am attempting to query the permissions that role has been granted.
I am using sp_helprotect, but dont fully understand the results: does this indicate that the user can only connect create a table? but the role cannot connect by default? Please help
Is there another SP that would list full role permissions?
Owner Object Grantee Grantor ProtectType Action
. . TestPerm dbo Grant Create Table
. . TestUser dbo Grant CONNECT