Problem Definition

Database Setup for Oracle has an instruction to grant predefined roles – CONNECT, RESOURCE. but these roles are not recommended by Oracle because they should be outdated in near future.

Suggested Solution

Change the instruction to grant

• CREATE SESSION
  (to replace the role in CONNECT)
• CREATE CLUSTER
• CREATE INDEXTYPE
• CREATE OPERATOR
• CREATE PROCEDURE
• CREATE SEQUENCE
• CREATE TABLE
• CREATE TRIGGER
• CREATE TYPE
  (to replace the role in RESOURCE)

Why this is important

Because these predefined roles may not be created automatically as described in below.
Configuring Privilege and Role Authorization-- Predefined Roles in an Oracle Database Installation

Note: Oracle recommends that you design your own roles for database security rather than relying on this role. This role may not be created automatically by future releases of Oracle Database.