June 9, 2014 at 5:12 pm
By using management studio, I grant a user database reader and db writer. And also execute on database level.
My question is in future if I come back to see what permission this user has, I can see clearly he is a db reader and db writer.
But it is not easy for me to glance that he has execute rights on database. How can I easily see or script out all the permissions for this user?
THanks
June 10, 2014 at 1:57 am
Take a look at this thread:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 10, 2014 at 4:48 am
Just a suggestion, instead of granting permissions to a user, create a role, assign that role permissions, add the user to the role. That way, you can give multiple users the same permissions over and over easily. You'll still have to run queries to see those permissions, but it makes management so much easier.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply