Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
duanecwilson
Constraint Violating Yak Guru
273 Posts |
 Posted - 2012-01-19 : 14:06:58
|
| I need to create a script to create a role called 'Documenters' that when logins are added to it will be able to view the data and object definitions and properties on SOME of the databases on a server, but not all. Then I want to be able to add some other logins to that role. The purpose is for them to document some of the databases, but not all, and not be able change anything. Basically read access on everything. How can I do this?Duane |
|
|
|
|
|
Create role help and add/revise permissions