Home » SQL & PL/SQL » SQL & PL/SQL » how to ungrant (get back) the permission. that we have given to one user.
how to ungrant (get back) the permission. that we have given to one user. [message #190006] Tue, 29 August 2006 00:35 Go to next message
youthsen
Messages: 45
Registered: August 2006
Member
hi pals

i have cretead one user "mani/maran (username/password)" and i gave the following grants to that user.

1, create table
2, create session
3, resource

now i want to scrap (ungrant or get back) that permission.

how to do this.

thanks a lot in advance.
Re: how to ungrant (get back) the permission. that we have given to one user. [message #190008 is a reply to message #190006] Tue, 29 August 2006 00:43 Go to previous message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

 use revoke.

revoke create session from mani



regards,
Previous Topic: YTD Accumulation of Months
Next Topic: CASE END
Goto Forum:
  


Current Time: Tue Dec 06 13:55:43 CST 2016

Total time taken to generate the page: 0.12011 seconds