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