How to find my permissions in a SQL Server database?

Question

I'm a user of a SQL Sever database, and I want to know my access rights / permissions in the database I'm using. What SQL query should I use to do so?

Thanks

Answer 1

I think the easiest way would be:

SELECT * FROM fn_my_permissions(NULL, 'SERVER');  
GO 

I tried it in SQL Server 2008.

Ref: https://learn.microsoft.com/en-us/sql/relational-databases/system-functions/sys-fn-my-permissions-transact-sql