hseman.sql

Visual Basic + Oracle 9i数据库应用系统开发与实例《小区物业管理系统》,界面还行

-- 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;