Re: Grant Execute On all packages of another user

The tool Hora 4 has a menu item
Schema/Create Grant Script ...
which generates what you need. You can use the 30 days free trial version of Hora 4 for this purpose. May be you like the tool. See http://www.keeptool.com.

regards Jan Dieckmann

AK wrote:

> Hello,
>
> I use OWAS 3.0 and Oracle 7.3.4 and i have developped an application
> under one schema (one user).
> Now, i want to use the DataBase-Controlled Authentification. So, each
> user will connect whith his database username and
> password.
> However, i want that these users can execute all the package of the
> application who are stored in another schema.
> I think that i have to create synonyms for each package and to grant
> execute too.
> How can i do this.
> Thanks.
Received on Fri Nov 05 1999 - 09:41:12 CST