My Oracle Support Banner

SSE_ROLE & Securities (Doc ID 497920.1)

Last updated on AUGUST 28, 2023

Applies to:

Siebel CRM - Version 7.5.3 [16157] and later
Siebel System Software - Version 7.5.3.2 [16168] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (MidMarket)
Version: 7.5.2.100 [15252] MME and later including 15,16,17
Database: Oracle 9.2.0.2 and above
Application Server OS: Any
Database Server OS: Any

This document was previously published as Siebel SR 38-1166699088.



Symptoms

After the customer's security team had reviewed the Siebel installation environement they came up with many suggestions regarding the security of this installation. Requesting advice on the following:

User authentication in Siebel is performed directly through Oracle Server DB account.
The customer is not using LDAP or any other 3thd party method of authentication.

When installing the system, the SSE_ROLE role is created on the Oracle instance and all objects that are created under the SIEBEL schema are granted to this role. Later the users will be assigned this role.

=> Question:
Can we create a sub-set of this default role on the Oracle instance, and prevent the users from access to a few critical tables?

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.