Home » SQL & PL/SQL » SQL & PL/SQL » granting privlages to newly created user (oracle 9i)
icon9.gif  granting privlages to newly created user [message #320778] Fri, 16 May 2008 04:16 Go to next message
Messages: 1
Registered: May 2008
Location: delhi
Junior Member
I have created a user and granted him the privlages of create session and create table
and they worked on acordingly

But when i am revoking these permission from the user my server showing me that the revoke suceeded

let say i revoked the permission of create table by the command

revoke create table from new_user

the revoke is suceeded

but when i am connected to the new user and creating the table
the table is been created.

so i want the way how to revoke these privlages from the user
Re: granting privlages to newly created user [message #320780 is a reply to message #320778] Fri, 16 May 2008 04:24 Go to previous messageGo to next message
Michel Cadot
Messages: 65154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Don't rate your own question before there is any reply. We know you are very satisfy of the questions you post but this is not the purpose of rating.

2/ Post the whole SQL*Plus session you did
Don't forget to format it accordingly to OraFAQ Forum Guide, "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Use the "Preview Message" button to verify.

Re: granting privlages to newly created user [message #320812 is a reply to message #320778] Fri, 16 May 2008 05:47 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Check to see if your user has been granted the CONNECT role - that provides the CREATE TABLE privilege too.
Previous Topic: ORA_ROWSCN functionality
Next Topic: quering list partition
Goto Forum:

Current Time: Wed Aug 23 06:56:54 CDT 2017

Total time taken to generate the page: 0.01732 seconds