Re: check user tablespace quota???

From: Andy Klock <andy_at_oracledepot.com>
Date: Wed, 18 Jan 2012 12:11:02 -0500
Message-ID: <CADo_RaOED+_dv-NUC0r34xEe=C5uvPAPT8F7aJ+Wdma8WWGkYQ_at_mail.gmail.com>

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_at_lazard.com> 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
>
>
>

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

Received on Wed Jan 18 2012 - 11:11:02 CST