Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: corret approach/sql to grant differnt logins rights to add/mod/del schema elements for differnt schemas
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.
Received on Sun Apr 15 2007 - 15:21:35 CDT