SET_AUTHENTICATION_MODE¶

Applies to: ORAFlex

This command is used to control what mode the user logs in as. When DEFAULT is passed, the user will be logged in with the default privileges given to it. When SYSDBA is passed, the user will be logged in with the roles assigned to the sysdba user, most likely full control over the database.

Syntax

SET_AUTHENTICATION_MODE of Oracle to {SYSDBA/DEFAULT}

Example

SET_AUTHENTICATION_MODE of Oracle to DEFAULT