Re: Grant two table spaces to a user / Role grants

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Sat, 14 Aug 2004 19:40:02 GMT
Message-ID: <mUtTc.11141$X12.7246@edtnps84>

Jawahar Rajan wrote:

> CREATE user user1 identified by XXXX default tablespace1, tablespace2.
>

Kind-of-a funny statement, don't you think? ... 'default' is the one used when nothing else is specified, so how would it be able to decide between the two?

What you want is to Grant a specific quota (or UNLIMITED use) in a TABLESPACE to the user.

Check out the GRANT statement in the SQL Language Reference Manual, or under the SQL Syntax section at http://docs.oracle.com You might also check out the 'CREATE USER' syntax while you are there.

Or, if you can't be bothered with documentation, fire up the Oracle Enterprise Manager and point-n-click your way to happiness.

/Hans Received on Sat Aug 14 2004 - 14:40:02 CDT