How to grant user permission to view specific views

  • ALIF-662928

    SSCertifiable

    Points: 6054

    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....

  • Luis Cazares

    SSC Guru

    Points: 183633

    If he creates the views and has access to the views, what's the problem?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • ALIF-662928

    SSCertifiable

    Points: 6054

    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...

  • Luis Cazares

    SSC Guru

    Points: 183633

    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.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply