users.sql

Visual Basic + Oracle 9i数据库应用系统开发与实例（企业购销存管理系统）界面简洁,数据库完整,还不错~适合学生利用和使用!

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