Grant quota on second table space to a user

From: Jawahar Rajan <jrajan_at_nc.rr.com>
Date: Mon, 16 Aug 2004 03:09:10 GMT
Message-ID: <qzVTc.196077$tH1.10022985@twister.southeast.rr.com>

All,
I have an oracle set up as follows.

Schema = mySchema owned by owner1

Using Owner1 I have created two users user1 and user2 and I grant select, update and insert and execute on objects in mySchema owned by owner1.

The default table space is myTblSPC but I also have a second tablespace called myTblSPC_Audit for audit tables.

My question
User1 has the additional privillege of creating tables in the table space myTblSPC, but I am unable to create a table in the tablespace myTblSPC_Audit. because I have not granted a quota to user1 on that tablespace.

Can I grant quota on two separte tablespaces to user1? how would /could I do this? (syntax?)

Any help is appreciated.

Thanks in advance

Jawahar Received on Sun Aug 15 2004 - 22:09:10 CDT