Oracle9i + PL_SQL学习笔记<2>

1.为表创建唯一索引，索引字段为emp_id
create unique index ibx_emp on employee(emp_id)
2.创建用户，赋管理员权限
create user user1 identified by user1;
grant resource ,connect to user1;
3.授权操作
grant all on employee to user1;
revoke delete on employee from user1;
4.清空表
truncate table employee;
5.删除索引
drop index ibx_emp;
6.赋于用户执行某过程的权限
grant execute on procedurename to username