Post reply

Grant user access to only create view

  • December 7, 2012 at 8:14 am

    #285971

    Hi,

    I have a user that currently only has read access to database XX, I want to elevate that users access to create views also but nothing else.

    Thank you in advance!

  • December 7, 2012 at 10:16 am

    #1566693

    well if they are going to create views, then they need at least two more permissions don't they?

    VIEW DEFINITION, so they can see other table structures,and db_datareader (which you said they already had) on all tables, so they can select from other items to build the views.

    take a look at these two threads on the same subject, it might help:

    create a new db role that can only create, alter and drop VIEWs

    Permission to Create, Modify & Delete Views only.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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