Re: way to grant schema privilege
Date: Mon, 28 Sep 2009 14:01:26 -0700 (PDT)
Message-ID: <61540.39799.qm_at_web53608.mail.re2.yahoo.com>
Hi Goulet, Richard,
Could show an example for the proxy clause usage to grant schema level privileges.
.Raju
From: "Goulet, Richard" <Richard.Goulet_at_parexel.com> To: mccdba1_at_yahoo.com; oracle-l_at_freelists.org; oracle-db-l_at_Groups.ITtoolbox.com Sent: Monday, September 28, 2009 11:12:54 AM Subject: RE: way to grant schema privilege
Look under the proxy clause of alter user in the sql reference manual.
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc
Sent: Monday, September 28, 2009 2:07 PM
To: oracle-l_at_freelists.org; oracle-db-l_at_Groups.ITtoolbox.com
Subject: way to grant schema privilege
On ORACLE 10GR2 and 11G is it possible grant access privileges on schema level NOT table/view level.
for example, I want grant 'select, update, delete" on one schema (all object under that schema) to another person. Is it possible?
Thanks.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 28 2009 - 16:01:26 CDT