Fernando Nunes wrote:
> DA Morgan wrote:
>
> Desupported already?! I thought it was about to reach end of support
> (with 11 comming up)... Plea$e $upgrade$... keep Gartner happy! :>

http://www.oracle.com/support/librar...-datasheet.pdf
My mistake ... desupport begins in 9 days.

> If I recall correctly if you create a procedure with a user that has the
> necessarily privileges over the tables, a third user cannot execute the
> procedure if he doesn't have the underlying table privileges... Does it
> ring a bell? I'll try to clarify this with him...

Your question is quite clear and your DBAs are partially correct. The
issue is the security model for compiled objects and it can be
configured to work either way on a procedure by procedure basis. With
DEFINER RIGHTS the user does not need permission to the underlying
tables/view. With CURRENT_USER rights permission must be granted. HTH.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)