Connecting Tech Pros Worldwide Forums | Help | Site Map

dbms_alert_info table access from a schema

Ping
Guest
 
Posts: n/a
#1: Jun 27 '08
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
Guest
 
Posts: n/a
#2: Jun 27 '08

re: dbms_alert_info table access from a schema


"Ping" <pl3@njit.eduschrieb im Newsbeitrag
news:2daccd98.0312101521.794182a4@posting.google.c om...
Quote:
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
Quote:
from schema a ?
>
Thanks in advance!
>
Ping
Qualify the table name with the schema name.

hth,
Guido


Closed Thread


Similar Oracle Database bytes