role naming conventions

From: Ray Stell <stellr_at_cns.vt.edu>
Date: Fri, 27 Sep 2002 11:18:41 -0800
Message-ID: <F001.004DB70B.20020927111841@fatcity.com>

Oracle seems to be inconsistant in the way it names roles:

SQL> select role, GRANTED_ROLE from ROLE_ROLE_PRIVS;

ROLE                           GRANTED_ROLE
------------------------------ ------------------------------
DBA                            DELETE_CATALOG_ROLE
DBA                            EXECUTE_CATALOG_ROLE
DBA                            EXP_FULL_DATABASE
DBA                            IMP_FULL_DATABASE
DBA                            SELECT_CATALOG_ROLE
EXECUTE_CATALOG_ROLE           HS_ADMIN_ROLE
EXP_FULL_DATABASE              EXECUTE_CATALOG_ROLE
EXP_FULL_DATABASE              SELECT_CATALOG_ROLE
IMP_FULL_DATABASE              EXECUTE_CATALOG_ROLE
IMP_FULL_DATABASE              SELECT_CATALOG_ROLE
OEM_MONITOR                    CONNECT

Sometimes it's _ROLE and sometimes it not. Any strong recommendataion for local names of roles? Is there a good guide to naming in general? Thanks.

---

Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ray Stell
  INET: stellr_at_cns.vt.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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). Received on Fri Sep 27 2002 - 14:18:41 CDT