Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL Package Execution Privileges
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.
-- jeremyReceived on Fri Feb 07 2003 - 01:18:00 CST