dbms_alert_info table access from a schema

[Ping]

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

[Guido Konsolke]

"Ping" <pl*@njit.edu> schrieb im Newsbeitrag
news:2d**************************@posting.google.c om...

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