Re: check user tablespace quota???

Hi,
Even though resource will include unlimited tablespace privilege, it will 
not show as specific tablespace quota. If you explicitly allocate 
tablespace quota while creating user or by alter user, it will show in 
DBA_TS_QUOTAS view.

HTH

Mayen



From:   "dba1 mcc" <mccdba1@xxxxxxxxx>
To:     oracle-l@xxxxxxxxxxxxx
Date:   01/18/2012 11:47 AM
Subject:        check user tablespace quota???
Sent by:        oracle-l-bounce@xxxxxxxxxxxxx



I tried to check new user tablespace quota but can NOT find?

any ideal?


create user user1 identified by user1
default tablespace USERS
temporary tablespace temp;

grant connect, resource to user1;

SELECT USERNAME, TABLESPACE_NAME, MAX_BYTES "Max Quota"
from DBA_TS_QUOTAS
WHERE USERNAME='USER1';

no row select.
--
http://www.freelists.org/webpage/oracle-l






--
http://www.freelists.org/webpage/oracle-l

Other related posts: