Oracle9i + PL_SQL学习笔记

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