Re: dbms_alert_info table access from a schema

"Ping" <pl3_at_njit.edu> schrieb im Newsbeitrag news:2daccd98.0312101521.794182a4_at_posting.google.com...
> I have sys to grant the following to a schema:
>
> (login as sys from sqlplus 8.1.6 on linux)
>
> grant select any table to a;
> grant execute on dbms_alert to a;
> grant create any procedure to a;
>
>
> when i login as a, i still can NOT do a select on the table
> dbms_alert_info ,
> it says the table or view does not exist.
>
> what else do i need to grant to the schema so that i can see the
 table
> from schema a ?
>
> Thanks in advance!
>
> Ping

Qualify the table name with the schema name.

hth,
Guido Received on Thu Dec 11 2003 - 08:48:59 CET