Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Create User
Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<67sugugmj8h50qep2dib2a72cbc5m6qmmf_at_4ax.com>...
> >
> >Just out of curiosity, what privileges does connect (and resource for
> >that matter) grant?
> >
> >I haven't been a DBA in anger since V5 (i.e. before roles) when you
> >needed connect to get onto the database, resource to create objects
> >etc.
> >
> >CE
>
> select * from dba_sys_privs where grantee in ('CONNECT','RESOURCE')
> will answer your question
>
> Regards
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Deep sigh...
If only my DBA allowed my access to the DBA_ views :-(
CE Received on Wed Jun 26 2002 - 03:10:25 CDT