数据库的用户都没法删除库的，删除权限可以查看系统视图dba_sys_privs，根据需要进行授权如：

GRANT DROP ANY SCHEMA TO XXX;
GRANT DROP ANY TABLE TO XXX;
GRANT DROP ANY VIEW TO XXX;
GRANT DROP ANY PROCEDURE TO XXX;
GRANT DROP ANY SEQUENCE TO XXX;
GRANT DROP ANY TRIGGER TO XXX;
GRANT DROP ANY INDEX TO XXX;
GRANT DROP ANY CONTEXT INDEX TO XXX;
GRANT DROP ANY PACKAGE TO XXX;
GRANT DROP ANY LINK TO XXX;
GRANT DROP ANY SYNONYM TO XXX;
GRANT DROP ANY MATERIALIZED VIEW TO XXX;
GRANT DROP ANY DOMAIN TO XXX;
GRANT DROP ANY CONTEXT TO XXX;
GRANT DROP ANY DIRECTORY TO XXX;
GRANT DROP ANY PARTITION GROUP TO XXX;
GRANT DROP ANY OPERATOR TO XXX;
GRANT DROP USER TO XXX;
GRANT DROP TABLESPACE TO XXX;

可以使用管理工具对系统权限进行授权

删库动作只能通过操作系统层面去执行，无法通过数据库用户去操作。按照您的描述直接给dba权限即可。
create user "cinole" identified by "cinole@123";
grant dba to "cinole";

使用双引号扩起来，"cinole"