Quick one today:
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:
-- -- 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:
-- -- List of permissions allowed on each securable -- SELECT * FROM fn_builtin_permissions('object') GO SELECT * FROM fn_builtin_permissions('schema') GO
Hope this helps,