My Oracle Support Banner

How to Determine If A Database User Has Access to Multiple DB Schemas Without Restarting The Server? (Doc ID 2017417.1)

Last updated on JANUARY 04, 2024

Applies to:

Oracle WebCenter Sites - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Goal

A WebCenter Sites database user should only be given access to its own schema. For example, the user should not be given DBA role or SELECT ANY DICTIONARY system privileges, which would allow the user to access other schemas in the same database.

When in doubt, this KM provides instructions for verifying the DB schemas that the user has access to without restarting the server, if ResultSet cache (Linked-Cache) is enabled over inCache.

Solution

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
Goal
Solution


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