Re: Cannot SELECT granted table inside package

From: Lev Smirnov <leo_at_dionis.sura.com.ru>
Date: Fri, 10 Nov 2000 09:03:14 GMT
Message-ID: <8ugdkg$hkg$1@nnrp1.deja.com>

In article <8ufc4g$rbv$1_at_localhost.localdomain>, software_at_localhost.localdomain (help desk) wrote:
> Hello all,
>
> I have a simple SELECT statement inside a package that accesses a
table in
> another user's schema (SELECT * FROM usera.some_table). The package
does
> not compile and the error message says that the identifier
> "usera.some_table" is unknown. I have been granted all on the said
table
> and can issue the same command from SQL*Plus without any problem. It
is
> only from the package where the issue comes up.
>
> Any idea how I might fix this?
>
> Thanks!
>

You must have been explicitly granted select privilege on usera.some_table. You cannot have obtained privileges through roles. Maybe it's your problem ?

Lev Smirnov
Brainbench MVP for Oracle Admin
http://www.brainbench.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 10 2000 - 03:03:14 CST