August 5, 2015 at 10:03 am
I have a user who needs access to views like(dbo.viewnameabc1,dbo.viewnameabc2 and so on...) dbo.viewnameabc*
and anytime the user creates the view he already have the permission to view those views....
August 5, 2015 at 10:25 am
If he creates the views and has access to the views, what's the problem?
August 5, 2015 at 10:30 am
Its not the user who creates the view, other users can create the view with that nametype, and that following user needs to have access to those specific name type views...
August 5, 2015 at 10:32 am
You could create a Schema and grant permissions to the user on that schema so the user will have permissions to the views on that schema.
Otherwise, you need to grant permissions on each object.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply