| table object not found [message #157350] |
Wed, 01 February 2006 18:54  |
kjm0001
Messages: 11
Registered: February 2006
|
Junior Member |
|
|
situation as follows:
user a grants select on table x to user b on db 1
a db link created on db 2 using connected user type
user b on db 2 can desc on table x including select on table x by way of using:
desc user_a.table_x@db_link.world
select * from user_a.table_x@db_link.world;
problem:
user b creates a procedure to select data using user_a.table_x@db_link.world...procedure compiles...but during testing the error is error on line n with object user_a.table_x@db_link.world not found...
what is going on??
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
