Prev: How to find transposed data and near misses
Next: Case Expression Performance Implication
From: Roy Goldhammer on 22 Jul 2010 10:54
Hello there

I have database with 10 schemas.

all the authorization of the schemas is dbo for security purposes.

I need to create user who can do anything on specific schema include create
and drop objects and don't have any access to other schemas.

Is there a way to do this?


From: Erland Sommarskog on 22 Jul 2010 11:41
Roy Goldhammer (royg(a)yahoo.com) writes:
> I have database with 10 schemas.
>
> all the authorization of the schemas is dbo for security purposes.
>
> I need to create user who can do anything on specific schema include
> create and drop objects and don't have any access to other schemas.
>
> Is there a way to do this?

Yes, you can grant CONTROL to a user on schema level:

GRANT CONTROL ON SCHEMA::guest TO someuser


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: How to find transposed data and near misses
Next: Case Expression Performance Implication