can you post the actual error... It seems the users does not have quota on= the tablespace to create the object.. -----Original Message----- From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]On Behalf Of drumil narayan Sent: Wednesday, December 15, 2004 11:48 AM To: askdba@xxxxxxxxxxxxx Subject: [askdba] Why its not creating table Dear All, I created user, given him connect, create session, create any table privs. and tried to create a table, it gave me the error as insuffcient privs for creating the table in tablespace_name. i checked the default tablespace of the user it was the same as mentioned in error.. then i assigned him dba privs, then it was able to create the table.. even i dropped the user twice...still the error persists.. can somebody point me what is the error, i do not want to give the user dba privs, but he should be able to create table.. what should i do.. TIA..Drumil ________________________________________________________________________ Yahoo! India Matrimony: Find your life partner online Go to: http://yahoo.shaadi.com/india-matrimony Confidentiality Notice=0D The information contained in this electronic message and any attachments to= this message are intended for the exclusive use of the addressee(s) and may contain confidential or= privileged information. If you are not the intended recipient, please notify the sender at Wipro or= Mailadmin@xxxxxxxxx immediately and destroy all copies of this message and any attachments.