Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

cannot access functions and synonyms with users read only privileges

Ken IJun 3 2013 — edited Jun 3 2013

Hi Gurus,

My oracle version is Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit on AIX machine.

I have created different users with read only privilege.Read access means user id should not be allowed to execute,update,delete SQL statement.
User id should be able to query (all tables,views,synonyms,functions,procedures,views,triggers,index,constraints,DB links ,user and to different schemas)

I have grant this to different users but users cannot able to view functions and synonyms.

GRANT CREATE SESSION,SELECT ANY DICTIONARY TO <users>;
GRANT SELECT ANY TABLE TO <users>;

I can connect to db and can view functions and synonyms but when users connect through crystal report they are facing some issue.

*Failed to open rowset.
Details:HY00:[DataDriver][ODBC Oracle Drivers][oracle]ORA 06550 line1,column8.
PLS-00904:insufficient privilege to access objects.
CISADM.CIAUDITRMC15
ORA 06550 Line 1,column8
PL/SQL statement ignored*

Is this a permission issue?
How to reslove this issue?

Thanks,
Meena