March 4, 2003 at 11:59 pm
Hi all, I'm a newbie with sqlserver db here. I'm wondering if someone can explain to me what's the fixed role and permissions in sqlserver 2000 db. For example, if a user A is granted with db_datawriter role in a database then would this user can update any tables within this db then my question is what about permissions? do I have to grant update permissions for this user for all of the tables within the db. Is this kinda redundant? thanks everybody
March 5, 2003 at 12:57 am
Take a look at sqlserver books online (BOL).
db_datawriter can update all tables in the databasen, except is that user has been denied write rights. look at BOL.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply