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:

Unknown said...

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

Anonymous said...


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

Unknown said...

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

vignes said...

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