view privilege

  • From: Ray Stell <stellr@xxxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 25 Apr 2005 14:30:19 -0400

From the 9.2 docs:

The owner of the view (whether it is you or another user) must have
been explicitly granted privileges to access all objects referenced in
the view definition. The owner cannot have obtained these privileges
through roles.

What is the logic behind the role restriction?  Why is a role less
secure in the ora architecture?  Thanks.
Ray Stell  stellr@xxxxxx  (540) 231-4109  Tempus fugit  28^D

Other related posts: