Sql Server : What are my permissions?

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:

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

Permissions On Securables

Hope this helps,

_Sqltimes

Read Full Post »