May 12, 2009 at 8:21 am
Apologies if this topic has been covered elsewhere but I'm a novice at this sort of thing.
I'd like to be to assign a certain role to some users of a database. They should be able to add/edit/delete data as well as create new queries and stored procedures. However, they should not be able edit existing tables or create new ones. Is this possible within the existing roles or schemas provided or do I need to build something from scratch. If so, how do I go about it?
Thanks for any help you can provide.
May 12, 2009 at 8:32 am
Well, you can do it with existing roles, but I would recommend creating your own role. The reason is that if you use the built-in db_datareader and db_datawriter roles, the user(s) granted those roles will have rights on all the tables/views in the database, even if you add some later that you don't want them to have rights to.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 13, 2009 at 7:08 am
Thanks very much. I'll give it a go.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply