Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL Package Execution Privileges

Re: PL/SQL Package Execution Privileges

From: Jeremy Ovenden <newspostings_at_hazelweb.co.uk>
Date: Fri, 7 Feb 2003 07:18:00 -0000
Message-ID: <MPG.18ad6e02319e3d959896b8@news.cis.dfn.de>


In article <3E42CBF6.8DC01052_at_exesolutions.com>, damorgan_at_exesolutions.com says...

>
> Look at setting up a specific role with a password and then assigning that
> role to the one or two people that are authorized for to exercise that
> privilege.
>
> Also consider ... create a procedure owned by SYS ... and grant execute on
> the privilege to specific users. The procedure should take full advantage of
> user-id, terminal, program, etc. (stuff in v_$session) to validate the user
> beyond the normal password.
>
> Daniel Morgan
>
>

Thanks Daniel, noted.

-- 

jeremy
Received on Fri Feb 07 2003 - 01:18:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US