Re: check user tablespace quota???

From: <Mayen.Shah_at_lazard.com>
Date: Wed, 18 Jan 2012 12:00:15 -0500
Message-ID: <OF4EDBCB73.C222D1B0-ON85257989.005D25D6-85257989.005D6829_at_lazard.com>

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_at_yahoo.com> To: oracle-l_at_freelists.org
Date: 01/18/2012 11:47 AM

Subject:        check user tablespace quota???
Sent by:        oracle-l-bounce_at_freelists.org

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 Received on Wed Jan 18 2012 - 11:00:15 CST