May 5, 2003 at 8:17 am
I understand fixed database roles but I have a question that I cannot find an answer to.
Do the db_datareader and db_datawriter fixed roles also control permissions to user views? I know they are tied to user tables but I don't know about views.
I am setting up some new databases with some views and I would like to use the fixed db roles. Is this possible, or will I have to setup some new roles and provide the permissions on the views to these new roles?
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
May 5, 2003 at 9:22 am
When you give access to READ|WRITE permissions mean FIXED DB ROLES, by default the user has access to the views you create.
May 5, 2003 at 5:00 pm
Works on views as stated above, not stored procedures.
Steve Jones
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy