Question re view privileges

From: William Wagman <>
Date: Wed, 10 Sep 2008 13:05:54 -0700
Message-ID: <>


I just demonstrated something to myself which took me by surprise and am wondering if I am perhaps missing something. Running Oracle 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.


Bill Wagman
Univ. of California at Davis
IET Campus Data Center
(530) 754-6208

Received on Wed Sep 10 2008 - 15:05:54 CDT

Original text of this message