RE: way to grant schema privilege

From: Goulet, Richard <>
Date: Mon, 28 Sep 2009 14:12:54 -0400
Message-ID: <>

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-----

[] On Behalf Of dba1 mcc Sent: Monday, September 28, 2009 2:07 PM To:; 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?



-- Received on Mon Sep 28 2009 - 13:12:54 CDT

Original text of this message