index > SQL Server Security > find what databases a particular user has permissions on and revoke them

find what databases a particular user has permissions on and revoke them

Hi experts,

I have multiple servers with multiple databases on each server. I need to find out what databases a particular user has access to and what this access is. I need to put this procedure in place for people who leave the company or move departments.

Is there a script out there that will do this for me across multiple databases on a server?

Many thanks and looking forward to your reply!

Orla

OrlaStears Tuesday, June 03, 2008 3:05 PM

What version of SQL Server are you on? I have one for SQL 2000, and one for SQL 2005.

Jonathan Kehayias Tuesday, June 03, 2008 8:04 PM

You can use google to search for other answers

Custom Search

More Threads

• Question regarding NTLM admin account and SQL Authentication Admin account

• Certificate request on SQL Server 2000

• Only users with sysadmin server role can access databases after making some changes to the public role permissions

• What persmissions to give to the application account to the Certificate

• How to force encryption on a per-database or per-user basis

• Hardware-assisted crypto?

• Windows Keyring

• Restrict access of an ASP.NET user to a subset of data for Web site reports.

• Need a sysadmin login

• Public role when user added as part of Windows Group