Sql Server : What are my permissions?
- Posted by Sqltimes
- On September 3, 2010
- 0 Comments
Quick one today:
My permissions:
Occasionally, we do want a quick way to check and gather a list of all permissions that my login has. Now there is a simple way:
|
1
2
3
4
5
|
---- Query my permissions on given securable--SELECT * FROM fn_my_permissions('SampleTable', 'object')GO |
What permissions are allowed?
Similarly, to query all possible permissions that could be given on a securable, there is an equally simpler way:
|
1
2
3
4
5
6
7
|
---- List of permissions allowed on each securable--SELECT * FROM fn_builtin_permissions('object')GOSELECT * FROM fn_builtin_permissions('schema')GO |
Permissions On Securables
Hope this helps,
0 Comments