Using public synonymes in stored procedures

From: nicranet <nicra_at_freenet.de>
Date: 16 Feb 2007 06:53:14 -0800
Message-ID: <1171637594.457952.169400@j27g2000cwj.googlegroups.com>

Hi,

I have a problem with one pubilc synonyme I using in a stored procedures. I try to find the role of SP-execute-user with:

SELECT granted_role INTO sRolle FROM DBA_ROLE_PRIVS where grantee=(SELECT USER FROM DUAL);

But if I try to create the procedure with this statment, I get this error :

LINE/COL ERROR

---

---

42/1 PL/SQL: SQL Statement ignored
42/38 PL/SQL: ORA-00942: Table or View does not exists

But DBA_ROLE_PRIVS is a public synonyme. It means everone can read this table.
I don't understand, what do I wrong?

Can anybody help me? Thanks in advance!

P.S. Sorry for my bad english! :-) Received on Fri Feb 16 2007 - 08:53:14 CST