Monday, February 2, 2015

Grant Permissions to create, alter, or view definition of a view in SQL Server


Let's assume you have a SQL Server user called reporting_user and it has select only access to some tables. To give that user the ability to create views use the following statements (be sure to change reporting_user to the name of your user).

grant create view to reporting_user
grant select on schema :: dbo to reporting_user
grant view definition on schema :: dbo to reporting_user

4 comments:

  1. As soon as I noticed this internet site I went on reddit to share some of the love with them. Hadoop Online Training .

    ReplyDelete

  2. Nice keep blogging and hadoop is the online training course in hyderabad
    hadoop online training

    ReplyDelete
  3. Bigdata hadoop online training course in hyderabad is the best online training course in hyderabad for more details refer at hadoop online training

    ReplyDelete
  4. I really appreciate for your efforts to make things easy to understand. I was really many students struggling to understand certain concepts but you made it clear and help me bring back my confidence.
    Selenium Training in Chennai
    Selenium Training Center in Chennai

    ReplyDelete