| creating new user [message #344989] |
Tue, 02 September 2008 02:13  |
krishnakkk
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  |
rajatratewal
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.
Regards,
Rajat
[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 |
JRowbottom
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
