SQL> create user zhenglei identified by zhenglei default tablespace users;
User created.
SQL> grant connect to zhenglei;
Grant succeeded.
SQL> alter user zhenglei quota unlimited on users;
SQL> grant create table to zhenglei;
Grant succeeded.
SQL> grant drop table to zhenglei;
grant drop table to zhenglei
*
ERROR at line 1:
ORA-00990: missing or invalid privilege
SQL> conn zhenglei/zhenglei
Connected.
SQL> create table xiaoliang as select * from dual;
Table created.
SQL> drop table xiaoliang;
Table dropped.
说明create权限就带有drop、update、insert权限
User created.
SQL> grant connect to zhenglei;
Grant succeeded.
SQL> alter user zhenglei quota unlimited on users;
SQL> grant create table to zhenglei;
Grant succeeded.
SQL> grant drop table to zhenglei;
grant drop table to zhenglei
*
ERROR at line 1:
ORA-00990: missing or invalid privilege
SQL> conn zhenglei/zhenglei
Connected.
SQL> create table xiaoliang as select * from dual;
Table created.
SQL> drop table xiaoliang;
Table dropped.
说明create权限就带有drop、update、insert权限