Oracle database access

[parameswar]

Hi,

can someone help in resolving the following error.

Oracle_Enterprise_0: APT_OraInstanceSet::opsInstalled(): prepare failed for query `select count(*) from sys.gv_$instance
';
please have the DBA run the following command: grant select on sys.gv_$instance to public.

I am getting this error while extracting data from oracle using oracle enterprise stage.
From the error itself i come to know that select priveleges is required on sys.gv_$instance. But customer is not giving this privileges due to security reason. Please help me to give a valid reason for this priveleges.

Thanks,
Param

[keshav0307]

the database user do not sufficient access to some sys tables, read the datastage manual( for oracle stage) for the list of sys tables, the user will need access.

[chulett]

Conversation migrated to the other post on this subject.