Re: how to hide public grant from a particular user
From: Lee Kyoung Rok <tunnel_at_hananet.net>
Date: Thu, 2 Dec 1999 00:40:25 +0900
Message-ID: <Dkb14.1810$sI3.59385_at_news.hananet.net>
Date: Thu, 2 Dec 1999 00:40:25 +0900
Message-ID: <Dkb14.1810$sI3.59385_at_news.hananet.net>
sachh <sachh_at_bigfoot.com>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦
news:823jd3$qu7$1_at_news.vsnl.net.in¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> I have created a user say scotterr.
> I want to hide the public grants from the user scotter
> i.e the user scotter should not be allowed to do DML
> operations using views such as
> ALL_OBJECTS;ALL_TYPES etc.
> can anyone help me add this security feature.
> regards
> sachin
>
>
alter user scotter identified by tigerer
quota 0 on user_data;
Give him 0 quota on every tablespace, then he cannot DML any more. Received on Wed Dec 01 1999 - 16:40:25 CET