Show TOC

SECURITY OptionsLocate this document in the navigation structure

SECURITY options are special category which are relevant to security of the database. It can be set at user level or PUBLIC level depending on options.

Changes to SECURITY database options take effect immediately. Requires the SET ANY SECURITY OPTION system privilege to set SECURITY database options.

No shut down and restart of the database server is required for the change to take effect.