Oracle Database B10772-01 Bedienungsanleitung PDF herunterladen (Seite 292)

100

101

Introduction to Enterprise User Security

11-8 Oracle Database Advanced Security Administrator's Guide

About Enterprise User Schemas

Enterprise users can retain their individual database schemas (exclusive schemas)

or share schemas if the enterprise security administrator maps them to a shared

schema.

Exclusive-Schema Enterprise Users If users want to retain their individual schemas in

the databases that they access, then

■ Create enterprise users in the directory, and

■ Create a global user schema for each user in each database that they access.

Creating separate accounts for each enterprise user on each database that they

access results in signiﬁcant overhead. Instead, creating enterprise users who access

a single, generic shared schema in each database increases the efﬁciency of the

enterprise user solution.

Shared Schema Enterprise Users To receive the real beneﬁt of the enterprise user

solution, you can use shared schemas for your enterprise users. For this strategy

■ Create enterprise users in the directory,

■ Create a single shared schema in each database, and

■ Create a single shared schema mapping in Oracle Internet Directory.

Mapping enterprise users to a generic, shared schema on each of the databases that

they access greatly reduces the overhead of creating separate schemas for each

enterprise user.

Shared schema enterprise users can be mapped to generic, shared schemas on all of

the databases that they access, or they can have exclusive schemas on some

databases and shared schemas on others. The shared schema mappings are stored

in the directory.

Kommentare zu diesen Handbüchern

Keine Kommentare

Oracle Database B10772-01 Bedienungsanleitung Seite 292

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Datenbanksoftware Oracle Database B10772-01