January 11, 2005 at 12:04 pm
Hello
I am looking for a script or procedure to find what kind of permissions every login on the server has. I need to find out who have an access to run, read sp and xp. A lot of servers, so trying to automize this somehow.
thank you in advance
January 11, 2005 at 12:32 pm
At the DB level you can use sp_helprotect. Therefore, if you automate the tying of login to user, you should be able to script something to go through each database and report back.
K. Brian Kelley
@kbriankelley
January 11, 2005 at 12:55 pm
thank you very much. that should be good enough
January 12, 2005 at 5:37 am
You Can use the PERMISSIONS function as well. I can't remember if you need to loop through the logins.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply