How to Determine If A Database User Has Access to Multiple DB Schemas Without Restarting The Server?
(Doc ID 2017417.1)
Last updated on APRIL 24, 2021
Applies to:Oracle WebCenter Sites - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
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.
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