Re: way to grant schema privilege
Date: Mon, 28 Sep 2009 14:07:08 -0700 (PDT)
I'll bet if you actually opened the documentation you might find one. They gave you a start.... how about you do some legwork yourself? (by the way, I looked, there is an example funny enough!)
Robert G. Freeman
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press)
Other various titles out of print now... Blog: http://robertgfreeman.blogspot.com The LDS Church is looking for DBA's. You do have to be a Church member in good standing. A lot of kind people write me, concerned I may be breaking the law by saying you have to be a Church member. It's legal I promise! :-) http://pages.sssnet.com/messndal/church/parachurch.pdf
From: Raju Angani <r_angani_at_yahoo.com> To: Richard.Goulet_at_parexel.com; mccdba1_at_yahoo.com; oracle-l_at_freelists.org; oracle-db-l_at_Groups.ITtoolbox.com Sent: Monday, September 28, 2009 3:01:26 PM Subject: Re: way to grant schema privilege
Hi Goulet, Richard,
Could show an example for the proxy clause usage to grant schema level privileges.
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.
Senior Oracle DBA/NA Team Lead
[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?