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 [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] 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: [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).