DA Morgan wrote:

>> My experience is with Oracle 9.
>
> Released 6 years ago in 2001 and currently desupported. That's keeping
> current?

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

By the way... You may clarify me a doubt... (I really should ask this in an
Oracle newsgroup...):

My fellow Oracle DBA tells me something about PL/SQL need to have explicitly
grants (user/table) while simple SQL doesn't... I know I'm not making much
sense, but in his words: "It's a different engine... SQL and PL/SQL"
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...

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...