Checking Owning User Account Using SQL

You can use SQL to check the owning user information.

1. To find the owning user of the DCF, enter this SQL query:

   select owning_user from data_clarification_forms where dcf_id=xxxxx;

2. If the owning_user query in the above step returns a value, execute this query, substituting the value for returned_value, to check if the owning user has an Oracle user account:

   select count(*) from oracle_accounts oa where ORACLE_ACCOUNT_NAME='returned_value';

   If the count is zero, the owning user does not have an account.

3. From the Admin menu, select Users, then select Oracle Accounts, and add the account.