Thursday 4 June 2020

How to check if Oracle Database Vault is enabled?


Below sql query can help us to identify if Oracle Database Vault is enabled or Disabled

SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';

PARAMETER                                          VALUE        CON_ID
-------------------------------------------------- -------- ----------
Oracle Database Vault                              FALSE             0


Database Vault is Disabled.

No comments:

Post a Comment

Was this Post Helpful?

Feel free to suggest your opinions in the comments section!