Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

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

From: dombrooks <dombrooks_at_hotmail.com>
Date: 15 Apr 2007 13:21:35 -0700
Message-ID: <1176668495.446731.141910@e65g2000hsc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US