hseman.sql

来自「Visual Basic + Oracle 9i数据库应用系统开发与实例《小区物」· SQL 代码 · 共 10 行

-- Create the user 
CREATE USER HSEMAN
  IDENTIFIED BY HSEMAN
  DEFAULT TABLESPACE USERS
  TEMPORARY TABLESPACE TEMP;
-- Grant/Revoke role privileges 
GRANT CONNECT TO HSEMAN;
GRANT RESOURCE TO HSEMAN;
-- Grant/Revoke system privileges 
GRANT UNLIMITED TABLESPACE TO HSEMAN;