Re: Blocking access to a deteminated schema
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: ballester.david@xxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 24 Oct 2008 17:39:31 +0100
This functionality is part of data vault. I would look at revoking the grants.
On 10/24/08, David Ballester <ballester.david@xxxxxxxxx> wrote:
> Hi people:
>
> I'm trying to block the access to all objects of one schema. I can alter it
> and block the connect but any other schema in the same database with grants,
> will be able to access the objects that I'm trying to block. I know than I
> can go to several role/privs views and extract data to konw who has grants
> to what object but i wanna know if exists a 'simple' command to block
> access on schema objects even in the case that you have grants to
>
> Thanks and regards
>
> D.
>
--
Sent from Google Mail for mobile | mobile.google.com
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
//www.freelists.org/webpage/oracle-l
Other related posts: