Probably because too many people use them.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des syst�mes
Technology Services | Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO | R�gion des Maritimes, MPO
E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: Jared Still [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 1:26 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re[2]: RESOURCE role
Probably a good idea.
I wonder why Oracle hasn't replaced these 2 roles,
or at least the RESOURCE role?
Jared
On Monday 30 April 2001 19:24, [EMAIL PROTECTED] wrote:
> I don't know about the rest of you, but whenever I create a new
> instance one of th first things that gets done is to drop the
resource
> role. I also get rid of Connect too.
>
> Dick Goulet
> ---------------------- Reply Separator ----------------------
> Subject: Re[2]: RESOURCE role
> Author: Jared Still <[EMAIL PROTECTED]>
> Date: 4/30/01 5:52 PM
>
> On Monday 30 April 2001 15:25, Jacques Kilchoer wrote:
> > The RESOURCE role is created via
$ORACLE_HOME/rdbms/admin/sql.bsq
> > You can look at that file, or you could query
> > DBA_ROLES
> > DBA_ROLE_PRIVS
> > DBA_SYS_PRIVS
> > DBA_TAB_PRIVS
> > DBA_COL_PRIVS
> >
> > Choosing a tablespace for a segment, however, is determined by
the
>
> quotas
>
> > allowed to the user. Check view DBA_TS_QUOTAS.
>
> Jacques,
>
> Granting RESOURCE to a user results in UNLIMITED TABLESPACE
> being granted directly to the user account.
>
> Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing
Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
