Is there a SQL statement that could be used to enable or disable the Oracle profile for VigilEnt Sec (NETIQKB31414)

Document ID:7731414
Creation Date:02-Feb-2007
Modified Date:08-Sep-2008
- Micro Focus Products:
  Secure Configuration Manager

Resolution

goal
Is there a SQL statement that could be used to enable or disable the Oracle profile for VigilEnt Security Agent for Oracle?

fact
VigilEnt Security Agent for Oracle 1.0

fact
VigilEnt Security Agent for Oracle 1.0 SR1

fact
VigilEnt Security Agent for Oracle 1.0 SR2

fact
VigilEnt Security Agent for Oracle 1.0 SP3

fact
VigilEnt Security Agent for Oracle 1.0 SP4

fix

Yes, the SQL syntax below can be used to verify the current status or alter the Oracle profile for the PASSWORD_VERIFY_FUNCTION. It is this function that allows VigilEnt Security Agent for Oracle to work on the Oracle user accounts.

To check the current Resource Limit for the PASSWORD_VERIFY_FUNCTION run the following syntax:
SELECT PROFILE, RESOURCE_NAME, LIMIT FROM sys.dba_profiles WHERE resource_name ='PASSWORD_VERIFY_FUNCTION';
To disable the Oracle "Default" profile from being "SQLCQR enabled":
ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION NULL;
To enable the Oracle "Default" profile to be "SQLCQR enabled":
ALTER PROFILE "Default" LIMIT PASSWORD_VERIFY_FUNCTION SQLCQR_VERIFY_FUNCTION;

Additional Information

Formerly known as NETIQKB31414