/*
首先在sys下先将查询权限grant给用户zkj
然后在zkj用户下再进行create table操作
*/
首先在sys下先将查询权限grant给用户zkj
然后在zkj用户下再进行create table操作
*/
--grant
Grant Select On Scott.Emp To Zkj;
Grant Select On Scott.Bonus To Zkj;
Grant Select On Scott.Dept To Zkj;
Grant Select On Scott.Salgrade To Zkj;
--create table
Create Table Emp As Select * From Scott.Emp;
Create Table Dept As Select * From Scott.Dept;
Create Table Bonus As Select * From Scott.Bonus;
create table Salgrade as select * from Scott.Salgrade;