SpaceCoastLife
asked on
SQL Server Database Role to Create Views
Can someone tell me the minimum database role that is required in order for a user to be able to create/edit views? I'm trying to avoid db_owner is possible.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How do you create a database role, like ROLE-1? I was going to call it db_createviews - would that be acceptable?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
modifying/creating view requires Alter permission on the schema. You need to create a new schema and provide access to that. Also create DDL triggers so that people cannot drop accidentally these.