callman.sql

来自「Visual Basic + Oracle 9i数据库应用系统开发与实例(项目售」· SQL 代码 · 共 11 行

-- 创建用户 
CREATE USER CALLMAN
  IDENTIFIED BY CALLMAN
  DEFAULT TABLESPACE USERS
  TEMPORARY TABLESPACE TEMP;
-- 设置角色权限 
GRANT CONNECT TO CALLMAN;
GRANT RESOURCE TO CALLMAN;
-- 设置系统权限 
GRANT UNLIMITED TABLESPACE TO CALLMAN;