Permissions for creating views

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

Permission error when trying to INSERT data

I have a user trying to insert a record into a table on my SQL 2000 server.
When she tries to do the insert she gets a message "Insert permissions denie
d
on object 'mytable', database 'mydatabase', owner 'dbo'". This user is a
member of an Active Directory group on my network. The AD group has rights t
o
the database on my SQL Server. The AD group has select, insert, update and
delete rights to the table in question. Yet even after all of this she is
still unable to insert records into this table.
What could be causing my problem? We recently changed the service log on
user for the MSSQLServer logon. I wouldn't expect this to make any differenc
e
in her ability to insert a record into this table. Am I wrong?
Any help would be greatly appreciated.Hi,
By any chance some one DENY INSERT to this user for this table.
Thanks
Hari
SQL Server MVP
"Snowmizer" <Snowmizer@.discussions.microsoft.com> wrote in message
news:104EB25F-C2F7-46A3-8A5B-7B9AC61A6F16@.microsoft.com...
>I have a user trying to insert a record into a table on my SQL 2000 server.
> When she tries to do the insert she gets a message "Insert permissions
> denied
> on object 'mytable', database 'mydatabase', owner 'dbo'". This user is a
> member of an Active Directory group on my network. The AD group has rights
> to
> the database on my SQL Server. The AD group has select, insert, update and
> delete rights to the table in question. Yet even after all of this she is
> still unable to insert records into this table.
> What could be causing my problem? We recently changed the service log on
> user for the MSSQLServer logon. I wouldn't expect this to make any
> difference
> in her ability to insert a record into this table. Am I wrong?
> Any help would be greatly appreciated.
>