What are all the Permissions Granted ?

Posted by PandianS under Sql Server category on 7/26/2010 | Views : 3580

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')

Bookmark It

Latest Code Snipptes