Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

PPM DB grants related query - CONNECT and RESOURCE

Highlighted
Sanjeev Kumar J
Occasional Advisor

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?

Please help!
Regards,
Sanjeev Jha

//Add this to "OnDomLoad" event