Managing Oracle Databases › Registering Oracle Databases › Oracle User Privileges › Oracle User Privileges for CA SRM Upgrades

Oracle User Privileges for CA SRM Upgrades

For clients running earlier versions of CA SRM and then upgrade to r11.5 or r11.6, the Oracle user needs the following privilege in order to successfully complete the data collection (substitute <BSRM username> with actual user name):

• Grant select on sys.dba_users to <BSRM username>
• Grant select on sys.dba_temp_files to <BSRM username>
• Grant select on sys.v_$tempstat to <BSRM username>
• Grant select on sys.V_$temp_space_header to <BSRM username>
• Grant create synonym to <BSRM username>

After granting these privileges, connect as <BSRM username> and create the following synonyms for the <BSRM username>:

• Create synonym dba_users for sys.dba_users
• Create synonym dba_temp_files for sys.dba_temp_files
• Create synonym v$tempstat for sys.v_$tempstat
• Create synonym v$temp_space_header for sys.v_$temp_space_header