数据库实验报告（头歌）实验五

第1关 创建用户和授权

create user u1 password 'rjxy1234!';
grant select,insert on teacher to u1;
grant select ,update(gum) on class to u1;

第2关 创建角色和授权

create user U2 password 'rjxy1234!';
create user U3 password 'rjxy1234!';
create role R1;
grant select,delete on teacher to R1 with grant option;
grant R1 to U2 with admin option;

 

第3关 收回权限

revoke all on teacher from U1,U2 cascade;
revoke all on teacher from R1 cascade;

第4关 逻辑备份

/home/kingbase/KingbaseES/V8/Server/bin/sys_dump -U SYSTEM -d testdb -f /tmp/testdb.dmp -F c
/home/kingbase/KingbaseES/V8/Server/bin/sys_dump -U SYSTEM -d testdb -f /tmp/teacher.dmp -F c -t teacher
/home/kingbase/KingbaseES/V8/Server/bin/sys_dump -U SYSTEM -d testdb -f /tmp/class.sql -F c -t class

第5关 逻辑还原库

create database exam;
/home/kingbase/KingbaseES/V8/Server/bin/sys_restore -U SYSTEM -d exam /data/workspace/myshixun/chapter/testdb.dmp -Fc

第6关 逻辑还原表

/home/kingbase/KingbaseES/V8/Server/bin/sys_restore -U SYSTEM -d exam /data/workspace/myshixun/chapter/teacher.dmp -Fc 
/home/kingbase/KingbaseES/V8/Server/bin/sys_restore -U SYSTEM -d exam /tmp/teacher.dmp  -Fc -t teacher