How to Determine If A Database User Has Access to Multiple DB Schemas Without Restarting The Server?

(Doc ID 2017417.1)

Last updated on JULY 07, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms