Re: where are privileges?

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 Mon May 17 1999 - 17:06:08 CDT