By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,544 Members | 2,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,544 IT Pros & Developers. It's quick & easy.

dbms_alert_info table access from a schema

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.