4.windows和Linux下创建oracle用户名表空间，表，插入数据，用户管理表等操作(三)

INSERT INTO MYSCOTT.EMP VALUES(7934, 'MILLER', 'CLERK', 7782, '23-1月 -82', 1300, NULL, 10);

commit;

-- 创建工资级别表并赋值

CREATE TABLE MYSCOTT.SALGRADE(

GRADE NUMBER,

LOSAL NUMBER,

HISAL NUMBER

)TABLESPACE ts_myscott;

INSERT INTO MYSCOTT.SALGRADE VALUES(1, 700, 1200);

INSERT INTO MYSCOTT.SALGRADE VALUES(2, 1201, 1400);

INSERT INTO MYSCOTT.SALGRADE VALUES(3, 1401, 2000);

INSERT INTO MYSCOTT.SALGRADE VALUES(4, 2001, 3000);

INSERT INTO MYSCOTT.SALGRADE VALUES(5, 3001, 9999);

commit;

--创建奖金表

CREATE TABLE MYSCOTT.BONUS(

ENAME VARCHAR2(10),

JOB VARCHAR2(9),

SAL NUMBER,

COMM NUMBER

)TABLESPACE ts_myscott;

------停止-----

-- 04创建新用户方案 通过MYSCOTTUSER1来访问数据库, 权限配置演示

CREATE USER "MYSCOTTUSER1" PROFILE "DEFAULT" IDENTIFIED BY "123456" DEFAULT TABLESPACE "USERS" ACCOUNT UNLOCK;

GRANT "CONNECT" TO "MYSCOTTUSER1";

GRANT SELECT ANY TABLE TO "MYSCOTTUSER1";

GRANT DELETE ON MYSCOTT.DEPT TO "MYSCOTTUSER1";

GRANT INSERT ON MYSCOTT.DEPT TO "MYSCOTTUSER1";

GRANT UPDATE ON MYSCOTT.DEPT TO "MYSCOTTUSER1";

GRANT DELETE ON MYSCOTT.EMP TO "MYSCOTTUSER1";

GRANT INSERT ON MYSCOTT.EMP TO "MYSCOTTUSER1";

GRANT UPDATE ON MYSCOTT.EMP TO "MYSCOTTUSER1";

commit;