In database permissions I have granted a user rights to create a view. When she tries to save the view (even save as) it automatically wants to save it to the dbo schema and says she does not have rights to save to the dbo schema.
Two questions:
1) Can I set it up to where she can save a view to a schema which she is the owner?
2) If not, then what permissions must be set to allow her to create / save views but not be able to create, etc. other objects such as tables and stored procedures?
From the description it seems like this is a question regarding tools (most likely Management studio).
I have moved the question to the appropriate forum, but if you have additional questions regarding the permissions please let us know.
Thanks,
-Raul Garcia
SDE/T
SQL Server Engine
|||Moved to Security|||You will need to grant alter on the schema and create view on the database to the user who wants to create views.
T-SQL:
grant create view to user1
grant alter on schema:bo to user1
go
HTH,
-Steven Gott
SDE/T
SQL Server
No comments:
Post a Comment