fn_my_permissions ( securable , 'securable_class' )
Value | Description |
---|---|
DATABASE |
Permissions on the current database |
OBJECT |
Table, View, Stored Procedure, etc. |
SCHEMA |
Database schema |
SERVER |
Server-level permissions |
SELECT * FROM fn_my_permissions(NULL, 'DATABASE');
SELECT * FROM fn_my_permissions(NULL, 'SERVER');
SELECT * FROM fn_my_permissions('dbo.YourTableName', 'OBJECT');
No comments:
Post a Comment
If you have any doubt or question, please contact us.