RE: Re[2]: RESOURCE role

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: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>

        -----Original Message-----
        From:   Jared Still [SMTP:jkstill_at_cybcon.com]
        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, dgoulet_at_vicr.com 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 <jkstill_at_cybcon.com>

        > 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: jkstill_at_cybcon.com

        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: ListGuru_at_fatcity.com (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: BoivinP_at_mar.dfo-mpo.gc.ca

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: ListGuru_at_fatcity.com (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).