February 10, 2009 at 2:38 pm
we have a partionted view which is created from 16 partionions .
What permissions I have to give to users so that they can execute the view?
I gave db_reader permission but still users are not able to access the views ...
any help is really appreciated.
Thanks.
February 10, 2009 at 2:40 pm
kiransuram19 (2/10/2009)
we have a partionted view which is created from 16 partionions .What permissions I have to give to users so that they can execute the view?
I gave db_reader permission but still users are not able to access the views ...
any help is really appreciated.
Thanks.
are you referring to "db_datareader" ?
Why not just: GRANT SELECT ON
* Noel
February 10, 2009 at 2:43 pm
maybe you're confused. You select from a view not execute. As noeld said just grant select on the view to whatever role\user
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2009 at 3:08 pm
we have 100's of users in a database how can I give select permission for all the users in a single shot?
Thank you
February 10, 2009 at 5:31 pm
create a database role and assign permissions to the role, then assign the users to the role
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply