Skip to main content

List users with their rights

To list the users with their rights, use below query. You have to system admin (sysadmin) rights to execute this query.
SELECT name,type_desc,is_disabled, create_date FROM master.sys.server_principals
WHERE IS_SRVROLEMEMBER ('sysadmin',name) = 1 ORDER BY name;
Labels:

Comments

Post a Comment

Popular posts from this blog

Table and its count

Table and its count To view all tables and its count by executing command and immediately, use below commands - MSSQL SELECT      sc. name   + '.' + ta. name   TableName,  SUM (pa. rows ) RowCnt FROM      sys.tables ta INNER   JOIN   sys.partitions pa      ON   pa.OBJECT_ID = ta.OBJECT_ID INNER   JOIN   sys.schemas sc      ON   ta.schema_id = sc.schema_id WHERE   ta.is_ms_shipped = 0  AND   pa.index_id  IN   (1,0) GROUP   BY   sc. name ,ta. name ORDER   BY   SUM (pa. rows )  DESC  
Post a Comment
Read more