Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Help on accessing package from another user's view
Ok, here's the problem. I have 3 users. Facility,
BPS & Test. Facility is the owner of a view named
error_item and has given select priv to user Test.
This view makes reference to a function from the
security package owned by BPS. BPS gave execute
permission on this package to facility.
Facility can select all the fields in the view including the one returned by BPS's security package function. But when user test selects from the view, he has access to every column except the one returned by the package.
Here's the error I got. I doubt though that it will be of any help.
SQL> select * from facility.error_item;
ERROR:
ORA-06550: line 1, column 12:
PLS-00201: identifier 'BPS.SECURITY' must be
declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
no rows selected
Question now is can TEST not run the view because he has not execute priv on the package? Even though the owner is FACILITY and he has access? What if FACILITY was given WITH GRANT OPTION? No, that wouldn't do anything about it would it? It simply means he can give execute to other users for the package he's been granted access.
Any other ideas or confirmation on my theory would be greatly appreciated.
Eric A. Gravel
egravel_at_newbridge.com
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Sep 28 1999 - 09:38:37 CDT
![]() |
![]() |