Question re view privileges
- From: William Wagman <wjwagman@xxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Sep 2008 13:05:54 -0700
Greetings,
I just demonstrated something to myself which took me by surprise and am
wondering if I am perhaps missing something. Running Oracle 9.2.0.8.0 EE on
RHEL 64-bit. Here is the scenario...
schema X has a view, v1 which selects from table t1 owned by schema Y.
schema Y has granted select on t1 to schema X.
schema X has in turn granted select on view v1 to user Z.
When user Z issues the command
SQL> select * from X.v1;
ORA-01031, insufficient privileges is returned. In order to resolve this schema
Y had to
SQL> grant select on v1 to X with grant option;
My question. I didn't expect it would be necessary to issue the grant with
grant option. Am I missing something or is there another way to handle this? I
don't want to issue the grant to public and I am not particularly happy about
user X being able to grant select on view v1 to others. If this is the way it
must be so be it but it took me by surprise.
Thanks.
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
--
//www.freelists.org/webpage/oracle-l
Other related posts:
