Mohan Kumar (9/4/2009)
HiI'm trying to create a sql server login with limited permissions as follows:
1. Database1 - tables read only.
2. Database2 - GRANT Select / Insert / Delete data
3. Database2 - GRANT Create / Alter procedure (delete action not required)
4. Database2 - Execute all procedure/functions
5. Database2 - User should not alter the table structure.
With the above mentioned details, can I create a ROLE so that I can create multiple logins with the same access/limitations as mentioned above for different databases.
Kindly provide me the code.
Regards
Mohan Kumar VS
yes you can create a role to do this. in fact you will need two separate roles. One for each database.
I find that BOL (Books online) is the best way of finding this information out.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]