users.sql

来自「Visual Basic + Oracle 9i数据库应用系统开发与实例（企业购」· SQL 代码 · 共 13 行

CREATE TABLE OSSMAN.Users
  (UserName	Varchar2(50) Primary Key,
   Pwd	Varchar2(50),
   UserType	Number(1),
   EmpName	Varchar2(50)
  )
TABLESPACE USERS;
INSERT INTO OSSMAN.Users VALUES('Admin' , 'Admin' , 1, 'Admin');
INSERT INTO OSSMAN.Users VALUES('Orders' , 'Orders' , 2, 'Orders');
INSERT INTO OSSMAN.Users VALUES('Sales' , 'Sales' , 3, 'Sales');
INSERT INTO OSSMAN.Users VALUES('Stocks' , 'Stocks' , 4, 'Stocks');
INSERT INTO OSSMAN.Users VALUES('Account' , 'Account' , 5, 'Account');