Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

who is package executed as

Status
Not open for further replies.
Toe

Toe

Programmer
Joined
Oct 26, 2001
Messages
71
Location
GB
if i have a pl/sql packege owned by 'user1' is it *always* executed as that user ('user1')?

can it be the case that the packegeis executed as the user who called the package

thanks
 
Sort by date Sort by votes
use

authid current_user

in your procedure. That informs oracle to use the invoking users rights.

Bill
Oracle DBA/Developer
New York State, USA
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Chopstik
  • Locked
  • Question Question
How to identify a package based on a code snippet
Replies
1
Views
1K
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question Question
SQL SELECT - where date is null or greater than
Replies
9
Views
7K
carp
carp
rk68
  • Locked
  • Question Question
Display rows as column header
Replies
3
Views
403
Beilstwh
Beilstwh
kernal
  • Locked
  • Question Question
If there is a Fee on Class Level then that fee overrides Fee on Course Level
Replies
3
Views
442
kernal
kernal
Server Guy
  • Locked
  • Question Question
Solaris 10 update 9 iso file
Replies
0
Views
436
Server Guy
Server Guy

Part and Inventory Search

Sponsor

Back
Top