RE: way to grant schema privilege

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Mon, 28 Sep 2009 14:12:54 -0400
Message-ID: <6B0D50B70F12BD41B5A67F14F5AA887FD19610_at_us-bos-mx022.na.pxl.int>

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 Received on Mon Sep 28 2009 - 13:12:54 CDT