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]

Re: dbms_alert_info table access from a schema

"Ping" <pl3@njit.edusc hrieb im Newsbeitrag
news:2daccd98.0 312101521.79418 2a4@posting.goo gle.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