On 16 feb, 15:53, "nicranet" <n..._at_freenet.de> wrote:
> 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! :-)
Grant the owner of the procedure access to the tables/view.
PL/SQL is anonimous; it does not know of roles, so you
need direct (a.k.a object) access
Received on Fri Feb 16 2007 - 09:04:30 CST
