Re: Blocking access to a deteminated schema

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

On 10/24/08, David Ballester <ballester.david_at_gmail.com> 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
--
http://www.freelists.org/webpage/oracle-l