Home » SQL & PL/SQL » SQL & PL/SQL » creating new user
creating new user [message #344989] Tue, 02 September 2008 02:13 Go to next message
Messages: 4
Registered: August 2008
Junior Member
hi everybody...
my name is chaitanya...

i have some questions..

suppose i have created a new user...i logged in as system administrator in 10g.
a new user have been created successfully...
now i have been connected to that user...
while i created a user a mentioned the tablespace...
now i created a table..
now i got an error that cannot create table in system tablespace....

i enquired some persons,they replied me that "untill the adminstrator grants the table space u cannot create tables in your account" is it true?
please help me...
Re: creating new user [message #344998 is a reply to message #344989] Tue, 02 September 2008 02:19 Go to previous messageGo to next message
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
while i created a user a mentioned the tablespace...

which tablespace??

you also need privileges to do the work.

just creating the user won't let you do anything.

you have to grant connect and resource privileges to make it connect to database.Then other privileges need to be granted to user.


[Updated on: Tue, 02 September 2008 02:21]

Report message to a moderator

Re: creating new user [message #345011 is a reply to message #344998] Tue, 02 September 2008 02:32 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
YOu need the system administrator to grant you a QUOTA on a tablespace in order to be able to create any objects which require storage. See Documentation

There are a large list of other privileges that you might need too:

The only privilege that you need to connect to the database is CREATE SESSION.

Be careful of RESOURCE and (under 9i or ealrier) CONNECT as they are roles containing quite a wide range of privileges. It is better to specifically grant only the privileges that are directly required.
Previous Topic: Regarding passing Array as a argument in the stored procedure/Function
Next Topic: Updating columns of one table based on other table
Goto Forum:

Current Time: Sat Aug 19 21:18:43 CDT 2017

Total time taken to generate the page: 0.43574 seconds