Re: selective object restrictions

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 05/25/05 

Date: Thu, 26 May 2005 00:39:03 +0530

Hi,

GRANT CREATE TABLE, CREATE VIEW, CREATE PROCEDURE to <USER_NAME>

This user can create table, view and procedure and manipulates the objects
he created. So cant do any activities on other owners objects.

Thanks
Hari
SQL Server MVP

"Support" <RemoveThis_Support@mail.oci.state.ga.us> wrote in message
news:OUYh5uTYFHA.584@TK2MSFTNGP15.phx.gbl...
> How can I create a user who has rights to create objects, ie, table, view
> and stored procedures in a database
> and no rights on any object someone else created.
>
> for example: in database DBA
> user A creates a table TABA
> user B creates a table TABB
> user A cannot deleted TABB
> Thanks
> T
>
>