OraFAQ Forum: SQL & PL/SQL » create a package with AUTHID=CURRENT

Home » SQL & PL/SQL » SQL & PL/SQL » create a package with AUTHID=CURRENT_USER by default

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create a package with AUTHID=CURRENT_USER by default [message #47394]

Sun, 15 August 2004 01:04

Sanjay Ray
Messages: 1
Registered: August 2004

Junior Member

Is it possible to create a database package with Invoker Rights by default, rather than Owners Rights, other than specifying AUTHID=CURRENT_USER in the script. (e.g. by setting an database parameter etc)

We are using Oracle 9.2 (9.2.0.5.0).

Thanks

Sanjay Ray

�

Report message to a moderator

Re: create a package with AUTHID=CURRENT_USER by default [message #47397 is a reply to message #47394]

Mon, 16 August 2004 08:32

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

No, the 'authid current_user' clause must be part of the object (function, proc, package) definition.

Report message to a moderator

Previous Topic:	SQL Query: for row level manipulations
Next Topic:	Sequence by group.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 22 09:34:34 CST 2025