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: Sat Jul 22 07:48:53 CDT 2017

Total time taken to generate the page: 0.12763 seconds