How to check who has access to symmetric keys in SQL Server

sql-server user-permissions symmetric-key
user3229801 picture user3229801 · Jun 13, 2014 · Viewed 8.2k times · Source

I would like to know all the users that have access to symmetric keys and the type of access they have. Can you please let me know how I can do this?

Answer

Dusan picture Dusan · Jun 13, 2014

Maybe this query can help:

select u.name, p.permission_name, p.class_desc, 
    object_name(p.major_id) ObjectName, state_desc 
from sys.database_permissions  p join sys.database_principals u
on p.grantee_principal_id = u.principal_id
where class_desc = 'SYMMETRIC_KEYS'

Related questions

cannot drop the view 'XXX' because it does not exist or you do not have permission

We migrated our servers from 2005 to 2014, User is able to delete it in the 2005 server But in 2014 we are getting the error as do not have permission or does not exits We have given to same permissions and even he …

Read More
How to find my permissions in a SQL Server database?

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

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More