SP_HELPGROUP ,SP_HELPROLE, SP_HELPROLEMEMBER

Both Procedures wil give the information about roles(groups) and Users(Members) in the Database.
SP_HELPROLE:
EXEC SP_HELPROLE @rolename='db_owner'
--OR
EXEC SP_HELPROLE
Gives the information about roles in the Datbase

SP_HELPGROUP:
EXEC SP_HELPGROUP @grpname='db_owner'
--OR
EXEC SP_HELPGROUP
Gives the Results about which user under which group.
SP_HELPROLEMEMBER:
EXEC SP_HELPROLEMEMBER @rolename='db_owner'
--OR
EXEC SP_HELPROLEMEMBER
Gives the results members of a role.

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server