Darryl,

Authorizaton of user for utPLSQL is a good idea for utPLSQL admin.

Let me throw in an idea ...
1. Create objects and packages in utPLSQL schema.
2. Grant all privileges to roles
3. Grant Roles to users
4. When user logs in, use ALTER SESSION SET CURRENT SCHEMA to set it to
utPLSQL schema, we may not need synonyms (private or public). This could be
achieved by using a DB event trigger (ALTER LOGON).

Of course this is an idea.

As for synonyms, we should use private synonyms.

Cheers
Raj
______________________________________________________
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
QOTD: Any clod can have facts, but having an opinion is an art !
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.