May 13, 2003 at 1:07 pm
Hi ALL,
In fact, what I need is to grant read access to all objects in all dbs. and number of dbs is growing. It's a pain in the butt (sorry) to grant the db role every time you have a new db in the server. In oracle, the 'select any table' is the only thing you need to do the trick. Thanks in advance,
-Yuan
May 13, 2003 at 1:17 pm
No, you can't.
May 13, 2003 at 1:39 pm
Allen is right, no user-defined server roles. What you can do as a work-around is make the requisite permission changes in the existing databases and then also in the model database. When a new database is created, model is copied. Therefore, any objects, users, roles, and permissions in model will be in your new database as well.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply