How to find my permissions in a SQL Server database?

sql sql-server database user-permissions access-rights
Nbenz picture Nbenz · Mar 20, 2018 · Viewed 15.9k times · Source

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

Eray Balkanli picture Eray Balkanli · Mar 20, 2018

I think the easiest way would be:

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

I tried it in SQL Server 2008.

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

Related questions

Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to replace a string in a SQL Server Table Column

I have a table (SQL Sever) which references paths (UNC or otherwise), but now the path is going to change. In the path column, I have many records and I need to change just a portion of the path, but …

Read More