What are all the Permissions Granted ?

PandianS
Posted by PandianS under Sql Server category on | Views : 2389
To a Particular Table / Objects :
SELECT permission_name FROM fn_my_permissions('<Table_Name>','Object')
To a Particular User :
SELECT permission_name FROM fn_my_permissions('<User_Name>','User')
To a Particular Login :
SELECT permission_name FROM fn_my_permissions('<Login_Name>','Login')
To a Particular Schema :
SELECT permission_name FROM fn_my_permissions('<Schema_Name>','Schema')
To a Particular Database :
SELECT permission_name FROM fn_my_permissions('<Database_Name>','Database')
To an active Instance/Server :
SELECT permission_name FROM fn_my_permissions(NULL,'Server')

Comments or Responses

Login to post response