User Rights - Help!!

Question

User Rights - Help!!

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

sstecher Ten Centuries Points: 1057 More actions · Answer 1

Thanks for the info Julian, your schema is a heck a lot simpler than the way I was trying to do it. I followed your suggestions and the everything is working out great. Except the test user I'm working with has all the access I want the user to have except the user can't drop anything? Is this right?

Thanks again for all the help

sstecher Ten Centuries Points: 1057 More actions · Answer 2

Ignore my last statement, I just had to wait a minute so the security schema could propogate.

Once again, I greatly appreciate everyone who help me get this matter resolved.

One more question, I like how the securoty is setup right now, but is there to give some one the exact same permissions on the database except the ability to get into the table design? Just curious

Shane Stecher

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 3

Shane,

I usually give db_datareader and db_datawriter permissions, that takes care of your tables. I think you have to give Execute permissions on stored procedures using your script. Create another role, give it everything except for the database design and assign users that should not change table design to this role.

Yelena

Regards,Yelena Varsha