IBM Support

Using a non-sys user for Oracle connectivity.

Question & Answer


Question

Using a non-sys user for Oracle connectivity.

Answer

If client does not want Sanovi agents to use the Oracle "sys" user and password to connect to their database you can create a separate user name with limited priviledges using the following steps.

?1. Telnet to the oracle server machine with 'oracle' user id.
?2. Connect to the oracle instance using sqlplus and "sys" user id and run the following commands:

?SQL> create user panaces identified by panaces
? Default tablespace users temporary tablespace temp;
?SQL> grant connect,resource to panaces;
?SQL> select * from v$pwfile_users;
?USERNAME SYSDB SYSOP
?----- ----------------------------
?SYS TRUE TRUE

?SQL> grant sysdba to panaces;
?SQL> select * from v$pwfile_users;
?USERNAME SYSDB SYSOP
?----- -----
?SYS TRUE TRUE
?PANACES TRUE FALSE

?SQL> grant dba to panaces;

?3. Login to Sanovi DRM GUI and complete Oracle Agent configuration with the newly created "panaces" user.
?4. Start Normal Copy.

[{"Business Unit":{"code":"BU051","label":"N\/A"},"Product":{"code":"SUPPORT","label":"IBM Worldwide Support"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB33","label":"N\/A"}}]

Document Information

More support for:
IBM Worldwide Support

Software version:
All Versions

Document number:
782627

Modified date:
02 November 2020

UID

ibm10782627

Page Feedback