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?
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply