I am a DBA and I need to grant a permission to an user in more than 60 databases. Can somebody help me?

Posted August 17, 2011

How to grant a permission to all the databases?

I am a DBA and I have got a request to add an user and grant him read access to all databases in a SQL server. Now, the problem is there are more than 60 databases hosted in the server and I do not wan to do it on all databases manually one by one. Is there any way out or a script through which I can grant the read permision to all the databases at one go?

Resolution: I have a script here to help you in this situation. Pls. refer to the following loink in my website :

http://www.sqldbaguru.com/permisison-all-db

Pls. feel free to add up and post your comments for any related queries.

Thanks,

Sujeet.

www.SqlDbaGuru.com

Posted in General
Tagged as grant permission to all the databases

Comments

There are no comments for this post.

No comments found

Add comment

Get the Expert's Advice.

Don't wait until you have got problems. Get the expert's advice, optimize your SQL Server and relax.

Contact for a SQL Sever Health Checkup Guidance today! 

Always reachable through:

  • - A Live Chat Session every Mondays and Thursdays.
  • - Call at  88-26-648-648  Dial 0091 before the number while calling from outside India.
  • - Mail me your questions at question@sqldbaguru.com