Grant Execute On all packages of another user

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 Oct 29 1999 - 01:39:49 CDT