Blocking access to a deteminated schema

From: David Ballester <ballester.david_at_gmail.com>
Date: Fri, 24 Oct 2008 18:07:26 +0200
Message-ID: <6a29f8b0810240907h5c10fa0mf860148545415f1c@mail.gmail.com>


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.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 24 2008 - 11:07:26 CDT

Original text of this message