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

<sybrandb_at_hccnet.nl> schreef in bericht news:2107c35mj8raunh5ajok8sb57i31q2pjca_at_4ax.com...
> 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

By the time you've read these manuals you'll be too old to go to any war.....
OP asked for a SHORT reference ;-)

Shakespeare Received on Thu Aug 16 2007 - 02:06:39 CDT