oracle考试参考资料

--11.删除触发器

drop trigger update_row_tri; drop trigger delete_tri;

--12.禁用/启动触发器

alter trigger insurance_row_tri disable; alter trigger insurance_row_tri enable;

alter trigger insurance_tri disable; alter trigger insurance_tri enable;

--实验指导书14 --1.创建用户 --(1)

create user user_130202021038 IDENTIFIED by user_130202021038 defaulttablespace ts_130202021038; --(2)

create user user_130202021038_sql IDENTIFIED by user_130202021038_sql account lock;

--2.查看用户

--(1)--select * from user_130202021038; --(2)--select * from user_130202021038_sql; --select * from v$session;

--(3)select username,default_tablespace from user_users;

--3.修改用户 --(2)

alter user user_130202021038 identified by sql_130202021038_user; alter user user_130202021038 account unlock; --4.权限管理 --(1)

grant create any table, create any index, alter any table, alter any index, drop any table, drop any index to user_130202021038; --(2)

grantsysoper to user_130202021038_sql; --(5)

revokesysoper from user_130202021038_sql; --5.创建角色

--(1)create role role_130202021038 ; --(2)create role role_130202021038_sql ; grant dba to role_130202021038_sql ; --6.查看角色

--(1)select * from role_130202021038 ; --(2)select * from role_130202021038_sql ; --7.修改角色

--(1)--alter user role_130202021038 default role --8.删除角色

--(1)drop role role_130202021038 ; --(2)drop role role_130202021038_sql ;