Re: How give full permission on a schema to a user

Sam wrote:
> Hi There,
> I created 3 different table spaces as default schema for 3 Oracle user,
> What's the easiest way to give them full permission
> on their schema to create, update,delete ... all kind of objects and
> add,delete,... records to their objects
> but minimum possible permissions on the system and other schemas,
>
> Thank you in advance - Sam

Can't imagine why you would create different tablespaces for different users as Oracle != SQL Server.

But when you create users you assign the quota:

CREATE USER ...
IDENTIFIED BY ...
DEFAULT TABLESPACE ...
TEMPORARY TABLESPACE ...
QUOTA ... ON ...;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org