Details
-
Suggestion
-
Resolution: Unresolved
-
None
Description
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.