SQL 2005 - Schema permissions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carlos Eduardo Selonke de Souza - 18 Oct 2005 15:22 GMT

Hello

I am trying to use the new schema model on SQL 2005 to control permissions
for users on my database.

I have two users on my database (User1 and User2) and a schema called
TestSchema.
I want to give permissions to both users to create/drop/alter objects
(procedures, views, tables) only on the TestSchema.
I read that a user can own a schema so it can control it. I also notice on
Management Studio that only one user can own a schema.

Is it possible to more than one user have "full control" of a schema? And
how to do it on SQL 2005?

PS: I used to post questions about SQL 2005 on the beta newsgroup, but today
when I tried to access it I was redirect to the MS Newsgroups.

Regards

Signature

Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.org

Reply to this Message

Joe Yong - 19 Oct 2005 04:46 GMT

Have you looked at GRANT ALTER? Let's the recipient alter, create and drop
the securable (schema or object) but not change the ownership. There is a
GRANT CONTROL but that's probably too much privilege.

joe.

> Hello
>
[quoted text clipped - 16 lines]
>
> Regards

Reply to this Message