I use system id to create an user ABC and grant create session,create table to ABC. So, I connect as ABC and try to create table tbl(tbl_id char(2)); However, an error comes out and says that ABC has not enough rights.
hi sophia, the syntax is correct, but to be possible the table space is full ,you can create table space and create tables there or you can change in a table space size. [ July 05, 2003: Message edited by: Maher Elsayd ]
HI, you also need to have a quota on the tablespaces you need to use. The easiest way is to connect using SYSTEM and GRANT UNLIMITED TABLESPACE TO ABC. You can also grant a quota (e.g. 5 MB) to a user. Just look in the SQL Reference on how to do that. The link to the online book list is here.
