How to Determine If A Database User Has Access to Multiple DB Schemas Without Restarting The Server?
Last updated on JULY 07, 2017
Applies to:Oracle WebCenter Sites - Version 188.8.131.52.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.
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