way to grant schema privilege

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Mon, 28 Sep 2009 11:07:01 -0700 (PDT)
Message-ID: <380529.35116.qm_at_web65711.mail.ac4.yahoo.com>



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

Original text of this message