Corporation Network Router User Manual

Configuring Enterprise User Security Objects in the Database and the Directory

12-14 Oracle Database Advanced Security Administrator's Guide

Task 3: Create Enterprise Roles in the Enterprise Domain

Use Enterprise Security Manager to create enterprise roles in the

OracleDefaultDomain by using the following steps:

1. Right-click the OracleDefaultDomain in the navigator pane and choose Create

Enterprise Role....

The Create Enterprise Role dialog box appears with the appropriate realm

Oracle Context and enterprise domain displayed.

2. Enter the enterprise role name in the Role Name ﬁeld.

3. Click OK. The new enterprise role is added under the domain in the navigator

pane.

For more information about this task, see "Creating a New Enterprise Role" on

page 13-27.

Task 4: Add Global Database Roles to Enterprise Roles

Use Enterprise Security Manager to add the global database roles that you created

in Task 1 on page 12-12 to the enterprise roles that you created in Task 3 by using

the following steps:

1. Select the enterprise role name in the navigator pane.

2. Choose the Database Global Roles tabbed window and click Add....

3. In the Add Global Database Roles dialog box, select the database from which to

obtain global roles. A database logon window appears, prompting you for a

username and password to authenticate to the database so global roles can be

fetched. Typically, this is a DBA logon to the database.

Note: You can use the database name that appears by default in

the Service ﬁeld to connect to the database if your Oracle home has

LDAP as one of its selected Oracle Net naming methods, or if this

name appears as a TNS alias in your local Oracle Net conﬁguration.

Otherwise, you can overwrite the Service ﬁeld with any other TNS

alias (from the database tnsnames.ora ﬁle), or by using a connect

string in the following format:

For example: machine111:1521:sales_db