Permissions with Packages

From: T.S.S. <tss_at_webspace.com.au>
Date: Tue, 10 Nov 1998 11:42:12 +1030
Message-ID: <364792EC.8415355D@webspace.com.au>

First, here is the situation.

I have a package PACKAGE_ONE compiled by USER_1 with their own permissions (synonyms, etc).

I have multiple other users which wish to use PACKAGE_ONE but they all have different permissions than USER_1 (i.e. different GRANTS).

My problem is that, when the other users execute functions within the PACKAGE_ONE package, the functions have the same permissions as USER_1 rather than the actual user (this is true).

Platform: Oracle 8.0.4 on UNIX Solaris

Qu: Is they a way of making sure that the user executing functions within the package, have only their own permissions rather than the creators permissions?

PS: We have got around this by splitting the packages up, but I was just wondering if there was another way of solving this problem.

Thanks.
T.S.S.
919 Fireblade Received on Mon Nov 09 1998 - 19:12:12 CST