Procedures
Thales procedures enable interfacing with the NAE Server directly from the Oracle database by accessing the procedures provided by CDP. These procedures can be used to map an Oracle database user name to a KeySecure Classic user name, execute a job, cancel a job, and add or update a job definition. Some of these procedures are contained in the ING_JOB_CONTROL package. Others stand alone in the database.
Set KeySecure Classic User Info (set_safenet_user_info)
This stored procedure is used to add a mapping between an Oracle database user and a KeySecure Classic user. This procedure is executed by the ProtectDB Manager when mapping database users to KeySecure Classic users. All the data stored by this procedure is encrypted and each row in the table is digitally signed to ensure the security of the data.
| Parameter Name | Data Type | In/Out | Description |
|---|---|---|---|
| dbUserName | varchar2 | In | The Oracle user name. |
| userName | varchar2 | In | The NAE user name. |
| userPassword | varchar2 | In | The NAE user’s password. |
Example
EXEC ingrian.set_safenet_user_info ('dba',
'NAEuser', 'NAEPassword');
----------------------------------------
PL/SQL procedure successfully completed.
