Re: check user tablespace quota???
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: Mayen.Shah@xxxxxxxxxx
- Date: Wed, 18 Jan 2012 12:11:02 -0500
Thanks Mayen. I completely missed that (probably what the OP was
originally asking).
So to follow along that line just check the privs for that user to see what
kind of tablespace access it has.
SQL> select privilege from dba_sys_privs where grantee = 'USER1';
PRIVILEGE
----------------------------------------
UNLIMITED TABLESPACE
On Wed, Jan 18, 2012 at 12:00 PM, <Mayen.Shah@xxxxxxxxxx> wrote:
> 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
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
