CREATE USER DFL
IDENTIFIED BY DFL
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 2 Roles for DFL
GRANT DBA TO DFL WITH ADMIN OPTION;
GRANT CONNECT TO DFL WITH ADMIN OPTION;
ALTER USER DFL DEFAULT ROLE ALL;
-- 1 System Privilege for DFI
GRANT UNLIMITED TABLESPACE TO DFL WITH ADMIN OPTION;
创建了一个DFL的用户 并授予权限。