Hi guys I am testing users' rights in sql server. However; I would like to add another column to sys.server_permissions which describes the name of endpoints. For instance;
I connect database engine -> From logins (SERVER BASE)->click a user->securable tab-> add endpoint (which is DAC)-> give some rights
But once i run this command (select * from sys.server_permissions) it gives just class_desc ;
100 SERVER 0 0 296 1 COSQ CONNECT SQL G GRANT
105 ENDPOINT 1 0 296 1 AL ALTER G GRANT
105 ENDPOINT 1 0 296 1 CL CONTROL W GRANT_WITH_GRANT_OPTION
105 ENDPOINT 1 0 296 1 CO CONNECT G GRANT
105 ENDPOINT 1 0 296 1 TO TAKE OWNERSHIP D DENY
I want have one more column which says the name of ENDPOINT such as TSQL Named Pipes,DAC etc...
I could not figure out where i can find it. Thanks in advance.
JOIN sys.server_principals AS SP ON SP.principal_id = s.grantee_principal_id
JOIN sys.endpoints AS E ON E.endpoint_id = s.major_id
Every day is a school day, and don't trust anyone who tells you any different.