Re: corret approach/sql to grant differnt logins rights to add/mod/del schema elements for differnt schemas

On 15 Apr 2007 13:21:35 -0700, "dombrooks" <dombrooks_at_hotmail.com> wrote:

>My personal preference is for users to issue SQL with fully qualified
>schema names and then as long as the objects are fully qualified (i.e.
><schema>.<object>) and the relevant privileges have been granted
>(possibly to roles that have subsequently been granted to the users),
>there's no need for application users to issue any ALTER SESSION SET
>CURRENT SCHEMA.
As a result you never can have various releases of an app in one database, and DBAs are forced to use your schema. Both are, as far as I am concerned, very undesirable.

Sybrand Bakker
Senior Oracle DBA Received on Sun Apr 15 2007 - 15:47:29 CDT