Re: find out what privileges needed - where to look up?

On Wed, 15 Aug 2007 14:13:04 -0700, ciapecki <ciapecki_at_gmail.com> wrote:

>hi,
>
>is there any short reference what privilege you need to run a
>statement.
>For example:
>when I run 'CREATE FUNCTION' what privilege I need?
>when I run 'CREATE AND COMPILE JAVA SOURCE' what privilege I need?
>
>how to find it out?
>
>thanks
>chris

Every section in the manual documenting commands describes what privileges you need to run it.
Yes, I am aware most people posting here would do anything to avoid reading the documentation, although I never saw someone volunteering to go to Iraq instead of reading it.

So when you want to know the privileges required for 'CREATE FUNCTION' just go to http://tahiti.oracle.com and type 'CREATE FUNCTION'. Go to your version, click 'SQL Reference' and you are there. The privileges are outlined under 'Prerequisites' It is THAT simple.
If I can do it, why are other people incapable of doing it?

-- 
Sybrand Bakker
Senior Oracle DBA