Re: select data from table owned by other user

The issue here is you have insufficient privilege. Tmp_user needs to grant you select privilege. Please run select table_name from all_tables where table_name = 'TMP_TABLE' before and after the grant, and you will see your table is known now.
Personally I avoid hardcoding owners, so IMO you need to create either a private or a public synonym as well.

Hth,

Sybrand Bakker, Oracle DBA

Tom Schelhorn <t.schelhorn_at_finec.de> schreef in berichtnieuws 8g153m$eus6$1_at_fu-berlin.de...
> Hi everybody!
>
> I've to select some data from a table owned by another user "tmp_user" .
> When I run the following code:
>
> CREATE OR REPLACE PROCEDURE ...
> ...
> BEGIN
> DECLARE
> CURSOR tmp_Cur IS
> SELECT * from tmp_table;
> ...
>
> I always get the error-message:
> PLS-00201:identifier 'tmp_user.tmp_table' must be declared
>
> I know that I've to declare 'tmp_table' before I can use it, but I
 could'nt
> find the syntax for that in oracle-docs.
>
> any help would be fine..
> Tom
>
>
>
Received on Thu May 18 2000 - 00:00:00 CDT