玩转Oracle10g实战教程全套PPT韩顺平.ppt

* * * sqlconn system/manger sqlgrant create session to 角色名 with admin option sqlconn scott/tiger@myora1 sqlgrant select on scott.emp to 角色名 [with grant option 不可带] sqlgrant insert,update,delete on scott.emp to 角色名 通过上面的步骤，就给角色授权了. * * * * select * from emp where empno=7788;--取得员工信息 * * * * * * 可以建表演示一下. * * 可以建表演示一下. * create table customer (customerId char(8) primary key, name varchar2(20) not null, address varchar2(30), email varchar2(30) unique, sex char(2) default 男 check (sex in(男,女)) , cardId char(18)) create table purchase (customerId char(8) references customer(customerid), goodsId