Siebel Business Process & Functionality (MOSC)

MOSC Banner

privileges

edited Jan 31, 2013 3:59AM in Siebel Business Process & Functionality (MOSC) 5 commentsAnswered
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                                                                                                                           

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center