i am having 300 databases in which i have to grant read access to all,How to grant read access to all databases in Sql Server 2000 please suggest
Mar 06 '12 at 01:22 PM
hello sorry to ask 'youruser' in the sence username please correct if i am wrong
yes it is the username
thanks a lot Robbin it worked one small question is there any difference in public and datareader as the user was executed as datareader but he was provided with public through the script please suggest if possible.
The public role is a special database role to which every database user belongs. The public role captures all default permissions for users in a database. It cannot have users, groups, or roles assigned to it because they belong to the role by default. It is contained in every database, including master, msdb, tempdb, model, and all user databases.
Thanks Robbin once again for your detailed clarification.
The actual snippet is quite simple
sp_addrolemember 'db_datareader', 'youruser'
Mar 06 '12 at 01:42 PM
Mar 06 '12 at 01:52 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Mar 06 '12 at 01:22 PM
Seen: 683 times
Last Updated: Mar 06 '12 at 03:13 PM
Is this normal for indexes from SQL 2000 to SQL 2005?
compatibility of publisher, subscriber and distributor
Totals across a rows columns and potentialy multiple rows
Hello I want the output like attachment in sql server........ so help me to make a stored procedure
Updating Multiple Columns with one UPDATE statement
What caused leap in space used from SQL Server 2000 to SQL Server 2005?
how to identify sql server deprecated features of 2000 and 2005 in 2008 server
Tables not shown when creating an ODBC connection
Database compatibility and application testing
SQL 2000/2005 on same server
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.