Re: check user tablespace quota???
- From: Mayen.Shah@xxxxxxxxxx
- To: mccdba1@xxxxxxxxx
- Date: Wed, 18 Jan 2012 12:00:15 -0500
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
