oracle创建用户脚本

ORACLE创建用户脚本

2009-05-14 22:52

 

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的用户 并授予权限。