Oracle assign grant and revoke privileges

Solved/Closed
priya - Sep 20, 2010 at 03:57 AM
 priya - Sep 27, 2010 at 05:00 AM
Hello,

i am working with oracle 9i. I use SQL+ to execute queries of SQL using username Scott and password tiger.
to implement TCL(transaction contorl language)- grant & revoke.
How to create users?

will you pleaze tell me how to assign grant and revoke privileges to users?
Related:

2 responses

closeup22 Posts 8922 Registration date Friday May 15, 2009 Status Member Last seen October 7, 2010 2,099
Sep 20, 2010 at 04:33 AM
Hi there,

Try using the link below it will be useful to your request:

http://www.adp-gmbh.ch/ora/sql/create_user.html

Thanks
0
i viewed this link.

http://www.adp-gmbh.ch/ora/sql/create_user.html

but when i tried to execute these queries the error was occured " insufficient privileges".

what is wrong? why these commands are not executing?
0