Re: where are privileges?

If it's not a privilege, why does it show up in user_sys_privs? I've noticed if someone has this privilege that imports will go to their

assigned tablespaces regardless of quotas, whereas if they do not have this
privilege, all objects will go to the default tablespace. When someone has
the unlimited tablespace privilege, it does not show up in dba_ts_quotas, it
shows up in sys_privs. Question is, how would I know that the resource role
contains that privilege. "RESOURCE" doesn't show up in this table either...

• Dc.

Vitaliy Mogilevskiy wrote:

> It's not a privilege it's a QUOTA:
> Here is the view to look at:
>
> SQL> desc DBA_TS_QUOTAS
> Name Null? Type
> ------------------------------- -------- ----
> TABLESPACE_NAME NOT NULL VARCHAR2(30)
> USERNAME NOT NULL VARCHAR2(30)
> BYTES NUMBER
> MAX_BYTES NUMBER
> BLOCKS NOT NULL NUMBER
> MAX_BLOCKS NUMBER
>
> +-------------------------------------------------------------+
> | Vitaliy Mogilevskiy |
> | Senior Consultant |
> | CORE Technology Group, Inc. |
> | E-mail: vit100gain_at_earthlink.net |
> | Fax : (707) 516-2163 |
> | Web Page: http://home.earthlink.net/~vit100gain/index.html |
> | *** Free DBA Script Library at my Web Page *** |
> +-------------------------------------------------------------+
>
>
> Doug Cowles wrote:
>
>> I've noticed that granting resource gives a user unlimited
>> tablespace.
>> Question is, how was I to know that? It's not in dba_sys_privs,
>> role_sys_privs,
>> role_role_privs etc., Is this something you have to just look up?
>>
>> - Dc.
>
Received on Tue May 18 1999 - 15:44:14 CDT