Stored Procedure running as USER

From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/07/03
Message-ID: <Pine.SUN.3.91.950703135739.24918B-100000_at_seatimes>#1/1

Most of the time allowing a stored procedure to run with the privileges of the creator of the stored procedure is OK.

However, there are a couple of procedures that I'm writing that really should run with the privileges of the end user who has the database open.

There is a note in the dmbs_sql package that states:

   "The operations provided by this package are performed under the     current calling user, not under the package owner...."

So, how does one create their package to do this?

--Steve

+----------------------------------------------------+


| Steve Butler          Voice:  206-464-2998         |


| The Seattle Times       Fax:  206-382-8898         |

| PO Box 70          Internet:  sbut-is_at_seatimes.com |

| Seattle, WA 98111    Packet:  KG7JE_at_N6EQZ.WA       |

+----------------------------------------------------+

All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Mon Jul 03 1995 - 00:00:00 CEST