King Arthur's Technology Round Table
Monday, 15 October 2012
View user permissions in SQL SERVER
Hi, To check your permissions just run the following queries and you'll get a list of assigned permissions
SELECT * FROM fn_my_permissions(NULL, 'SERVER'); USE YourDatabaseName; SELECT * FROM fn_my_permissions (NULL, 'DATABASE'); GO
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment