Re: How to make a package run under users permissions?

Hi,

stop using SYSTEM account for any other tasks than system-administration. Before you continue or even set up a production environment read some DBA-Handbooks (f.e. from Oracle Press) to learn about creating users, tablespaces and so on.

On Tue, 07 Apr 1998 16:18:04 -0600, umpaul18_at_cc.umanitoba.ca wrote:

>G'day!
>
>I have a stored procedure (report tool sort of) that I want to make available
>across schemas. The problem is that it executes under the permission set
>of the creator(SYSTEM), this isn't good. Is it possible to have a package
>do this(DBMS_SQL does)?
>
>If you're connected as 'scott' I want it to run as if 'scott' has created it,
>and thus access scott's objects.
>
>Any help wouldbe greatly appreciated.
>
>Stay Casual,
>
>Ken
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading

--

Regards

Matthias Gresz :-)

GreMa_at_T-online.de Received on Wed Apr 08 1998 - 07:11:29 CDT