make sure the user has either quota unlimited on that tablespace, or at least enough to accomodate the size of the table. _______________________________________ Patricia Eyenga President On-Pointe Database Services Co. Tel: 202-327-0877 Fax: 301-552-2290 Web: http://www.odsc.net Email: patricia.e@xxxxxxxx ---------------------------------------- From: sanjay.khangarot@xxxxxxxxx Sent: Tuesday, December 14, 2004 11:42 PM To: askdba@xxxxxxxxxxxxx Subject: [askdba] Re: Why its not creating table 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.