Eason [資料科學//Python學習/資料庫] & [拍片&剪片]

SQL> create user lxy identified by lxy default tablespace users;

User created.

SQL> grant create session,alter session,create table,create view,

2  create synonym,create cluster,create database link,create sequence,

3  create trigger,create type,create procedure,create operator to lxy;

Grant succeeded.

SQL> conn lxy/lxy

Connected.

SQL> create table m(id integer,name char(10));

create table m(id integer,name char(10))

*

ERROR at line 1:

ORA-01950: no privileges on tablespace ‘USERS’

上面錯誤的解决方法是在建立用户分配權限後,執行下面SQL語句:

SQL> alter user lxy quota 10M on users;

User altered.

SQL> conn lxy/lxy

Connected.

SQL> create table m(id integer,name char(10));

Table created.