isqlplus命令-9.docVIP

第九章 1.建立用户wang并指定口令为office。由于用户wang尚未被指定create session权限，因此，用户wang不能登陆oracle create user wang identified by office; conn wang/office; 2.建立用户xiaoli并指定口令为finance。指定一个默认表空间users和一个临时表空间temp。由于用户xiaoli尚未被指定create session权限，因此，用户xiaoli不能登陆oracle create user xiaoli identified by finance default tablespace users temporary tablespace temp; conn xiaoli/finance; 3.建立用户zhang和zhao并分别指定口令为archives与office。由于用户zhang和zhao尚未被指定create session权限，因此，用户zhang和zhao不能登陆oracle create user zhang identified by archives; create user zhao identified by office; 4.将用户wang的密码修改为gold alter user wang identified by gold; 5.将用户王删除 drop user wang; 6.授予用户xiaoli CREATE SESSION,CREATE USER,CREATE TABLE等权限，授予zhang、zhao CREATE SESSION权限 grant create session,create user,create table to xiaoli; grant create session to zhang,zhao; 7.授予用户xiaoli权限execute any procedure。给用户xiaoli授权时，使用with admin option选项，因此，用户xiaoli还可以将获得的execute any procedure系统权限再授予其他人 grant execute any procedure to xiaoli with admin option; 8.通过用户xiaoli授予用户zhang EXECUTE ANY PROCEDURE权限 conn xiaoli/finance; grant execute any procedure to zhang; 9.将系统权限creare session和execute any procedure授予所有用户 grant create session,execute any procedure to public; 10.查看授予用户xiaoli的系统权限 conn xiaoli/finance; select * from user_sys_privs; 11.查看授予用户zhang的系统权限 conn zhang/archives; select * from user_sys_privs; 12.收回用户xiaoli系统权限create table，之后再查看授予用户xiaoli的系统权限 conn system/oracle; revoke create table from xiaoli; conn xiaoli/finance; select * from user_sys_privs; 13.授予用户xiaoli在表departments上具有select、insert、update对象权限 grant select,insert,update on departments to xiaoli; 14.授予用户xiaoli在表teachers的wage、bonus列上具有update对象权限 grant update (wage,bonus) on teachers to xiaoli; 15.授予用户xiaoli在表students上具有select对象权限，并指定可选项with grant option grant select on students to xiaoli with grant option; select * from system.students; 16.通过用户xiaoli授予用户zhao在表students上具有select对象权限 conn xiaoli/finance; grant select on system.students to zhao; 17.查看用户xiaoli在表departments上具有哪些对象权限 conn xiaoli/finance; s