PPM DB grants related query - CONNECT and RESOURCE
Can anyone help with the following?
Q1.On the PPM and docuemntum schema, can the existing priviledge i.e. 'CONNECT' be replaced with 'CREATE SESSION'?
Q2.On the RML schema, can the existing priviledge 'RESOURCE' be replaced with SCHEMA_ROLE (Granted with CREATE DATABASE LINK CREATE LIBRARY CREATE PROCEDURE CREATE PUBLIC SYNONYM CREATE ROLE CREATE SEQUENCE CREATE TABLE CREATE TRIGGER CREATE VIEW DROP PUBLIC SYNONYM)?
According to the IT security auditors, the above accounts are granted with powerful roles (CONNECT and RESOURCE), can the roles be replaced with the suggested alternatives?