create view | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

create view

Which permission do I need to create view in sql database? THanks
The information you need you can find in BOL ‘Adding a Member to a Predefined Role’
True and BOL refers
CREATE VIEW permission defaults to the members of the db_owner and db_ddladmin fixed database roles. Members of the sysadmin fixed server role and the db_owner fixed database role can transfer CREATE VIEW permission to other users. 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.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>