Re: Using public synonymes in stored procedures

thanks for your solution, but I can't grant the direct access rights to the system tables. I solve this problem in other wise: i select the role with a simple sql-statement: "SELECT granted_role FROM DBA_ROLE_PRIVS where grantee=USER" and pass the reply as paramater to the stored procedure.
It works. :-) Received on Mon Feb 26 2007 - 07:30:15 CST