Re: Revoke Grant to public

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 25 Jul 2006 22:02:36 -0700
Message-ID: <1153846983.887055@bubbleator.drizzle.com>

Ashwin wrote:
> Ashwin wrote:

>> Hi,
>>
>> I have created a user 'sgbb'  he has grant privilege to public
>> now i hav to revoke the grant priviliege to public from the user sgbb
>> can anyone help me

>
> i hav granted him connect,resource while creating the user account
> how can i revoke
>
> Regards,
> Ashwin

revoke connect, resource from <user_name>; revoke grant any privilege from <user_name>;

Though I'd be inclined to substitute:

alter user <user_name> account lock; ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Wed Jul 26 2006 - 00:02:36 CDT