Password functions are not working on a system using the API interface. (NETIQKB27590)

fact
VigilEnt Password Manager for Oracle 6.0 SR4

fact
VigilEnt Password Manager for Oracle 6.0 SP5

fact
VigilEnt Security Agent for Oracle 1.0 SP3

fact
VigilEnt Security Agent for Oracle 1.0 SP4

symptom
Password functions are not working on a system using the API interface.

cause
This is a result of a misconfigured API (application program interface). The public synonyms, SQLCQR_LOGINCHECK and SQLCQR_PWD_CHECKANDSET are not in place or do not have the correct privileges.

fix
The following SQL syntax will verify that the public synonyms for the stored procedures have been created and have the appropriate privileges:

CHECKANDSET:
select count(*) from sys.dba_synonyms where owner='PUBLIC' and synonym_name = 'SQLCQR_PWD_CHECKANDSET' and table_owner='SQLCQR' and table_name='SQLCQR_PWD_CHECKANDSET'

select count(*) from sys.dba_tab_privs where grantee='PUBLIC' and privilege='EXECUTE' and owner='SQLCQR' and table_name='SQLCQR_PWD_CHECKANDSET'

LOGINCHECK:
select count(*) from sys.dba_synonyms where owner='PUBLIC' and synonym_name = 'SQLCQR_LOGINCHECK' and table_owner='SQLCQR' and table_name='SQLCQR_LOGINCHECK'

select count(*) from sys.dba_tab_privs where grantee='PUBLIC' and privilege='EXECUTE' and owner='SQLCQR' and table_name='SQLCQR_LOGINCHECK'

If an issue is discovered after running the SQL statements above, then please run the statements below:

create public synonym SQLCQR_PWD_CHECKANDSET for sqlcqr.SQLCQR_PWD_CHECKANDSET; grant execute on sqlcqr.SQLCQR_PWD_CHECKANDSET to public;

and

create public synonym SQLCQR_LOGINCHECK for sqlcqr.SQLCQR_LOGINCHECK; grant execute on sqlcqr.SQLCQR_LOGINCHECK to public;

Formerly known as NETIQKB27590