SQL> GRANT DROP TABLE TO CXT;
GRANT CREATE FUNCTION TO CXT
ORA-00990: 权限缺失或无效
怎么能删除自己建立的表呢 --这是一个小例子
SQL> create user dex2013 identified by xiaojun default tablespace users ;
User created.
SQL> grant create session to dex2013 ;
Grant succeeded.
SQL> alter user dex2013 quota unlimited on users ; --针对用户下的特定user表空间配额
User altered.
SQL> conn dex2013/xiaojun
Connected.
SQL> create table t (x int) ;
Table created.
SQL> drop table t ;
Table dropped. --可以看到,只要你是对象的拥有者(must be in your own schema),就可以drop,
view、SEQUENCE、INDEX同理.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26980368/viewspace-1253462/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26980368/viewspace-1253462/