Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insufficient privileges/can not grant to create tables

562711Jun 15 2007 — edited Jun 15 2007

I have just created database..

Connected as SYS I tried to Create user/schema as following:
CREATE USER "xsales" PROFILE "DEFAULT" IDENTIFIED BY "*******" ACCOUNT UNLOCK
GRANT "CONNECT" TO "ABDO"

Trying to create tables I recieved:
Failed to commit: ORA-01950: no privileges on tablespace 'USERS'

Then I tried to grant CREATE ANY TABLES to the user xsales to enable it to
run the script of create tables,but I recieved
ORA-01917: user or role 'abdo' does not exist

although I connected with xsales succefully

Can anyone help?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2007

Added on Jun 15 2007

#general-database-discussions

11 comments

10,823 views