SQL Server Performance Forum – Threads Archive
User Right’s QuestionI want to create a SQL user that can only create and delete and edit VIEWS. Can i do that, not sure how if so? I can set rights for existing views but what about just a right where that person can create and delete views?? thanks. ———————–
Richard Ryan King
"Why wait for the future when you can create it."
In EM, right click database, examine permissions tabsheet. You will see CREATE VIEW has a distinct permission. Also read the documentation for the GRANT command, in Books Online.
True, to create a view, the user must have CREATE VIEW permission. To execute the view, the user must have SELECT permission on the tables, views, and table-valued functions being referenced in the view, and EXECUTE permission on the scalar-valued functions being invoked in the view. _________