privileges
What are the proper privileges for the SIEBEL user in a SIEBEL database on an Oracle server?
I have a SIEBEL db with a SIEBEL user that was granted DBA role. We want to revoke DBA and grant the proper privileges.
We have these roles:
GRANTED_ROLE ADM DEF
-------------------- --- ---
RESOURCE NO YES
CONNECT NO YES
SSE_ROLE NO YES
And these system privileges.
System Privileges assigned to a user through roles
GRANTED_ROLE PRIVILEGE
-------------------- ---------------------------
RESOURCE CREATE TRIGGER
RESOURCE CREATE SEQUENCE
RESOURCE CREATE TYPE
RESOURCE CREATE PROCEDURE
RESOURCE CREATE CLUSTER
CONNECT CREATE SESSION
RESOURCE CREATE OPERATOR
I have a SIEBEL db with a SIEBEL user that was granted DBA role. We want to revoke DBA and grant the proper privileges.
We have these roles:
GRANTED_ROLE ADM DEF
-------------------- --- ---
RESOURCE NO YES
CONNECT NO YES
SSE_ROLE NO YES
And these system privileges.
System Privileges assigned to a user through roles
GRANTED_ROLE PRIVILEGE
-------------------- ---------------------------
RESOURCE CREATE TRIGGER
RESOURCE CREATE SEQUENCE
RESOURCE CREATE TYPE
RESOURCE CREATE PROCEDURE
RESOURCE CREATE CLUSTER
CONNECT CREATE SESSION
RESOURCE CREATE OPERATOR
0