Error Ora-00942 means you are attempting to execute an SQL statement that references a table or view which does not exist.
There is no such view or table present DBA_PASSWORD_VERIFY_FUNCTION, you might be mistaking in table or view name.
If you want to find out what users are using PASSWORD_VERIFY_FUNCTION, you need to find out which profiles are using the function and then see which users are assigned that profile.
select profile from dba_profiles where limit = 'PASSWORD_VERIFY_FUNCTION'; select username from dba_users where profile = "PROFILE_NAME";
Hey Dave,
Error Ora-00942 means you are attempting to execute an SQL statement that references a table or view which does not exist.
There is no such view or table present DBA_PASSWORD_VERIFY_FUNCTION, you might be mistaking in table or view name.
If you want to find out what users are using PASSWORD_VERIFY_FUNCTION, you need to find out which profiles are using the function and then see which users are assigned that profile.
select profile from dba_profiles where limit = 'PASSWORD_VERIFY_FUNCTION'; select username from dba_users where profile = "PROFILE_NAME";