Re: Blocking access to a deteminated schema

From: Niall Litchfield <>
Date: Fri, 24 Oct 2008 17:39:31 +0100
Message-ID: <>

This functionality is part of data vault. I would look at revoking the grants.

On 10/24/08, David Ballester <> 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 |

Niall Litchfield
Oracle DBA
Received on Fri Oct 24 2008 - 11:39:31 CDT

Original text of this message