数据库

最新推荐文章于 2024-07-15 08:30:00 发布

qq_39352549

最新推荐文章于 2024-07-15 08:30:00 发布

阅读量176

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/qq_39352549/article/details/84403176

版权

数据库专栏收录该内容

1 篇文章 0 订阅

订阅专栏

call stu5120160085.loan_prof(‘20051001’,‘2001232’)
call stu5120160085.huanshu_prof(‘20051001’,‘2001232’)

create user liqingfeng identified by ainiyu default tablespace data166;
grant connect to liqingfeng;
grant resource to liqingfeng;
grant select,delete,update,insert on stu5120160085.BOOKLIST to liqingfeng;
grant select,delete,update,insert on stu5120160085.booknm to liqingfeng;
grant select,delete,update,insert on stu5120160085.booktype to liqingfeng;
grant select,delete,update,insert on stu5120160085.forfeit to liqingfeng;
grant select,delete,update,insert on stu5120160085.loanbook to liqingfeng;
grant select,delete,update,insert on stu5120160085.reader to liqingfeng;
grant select,delete,update,insert on stu5120160085.subscrible to liqingfeng;
grant select,delete,update,insert on stu5120160085.subscrible to liqingfeng;
create role liqingfeng_role;
grant connect to liqingfeng_role;
grant execute on stu5120160085.HUANSHU_PROF to liqingfeng_role;
…

create or replace view view_reader as select booklist.isbn,booklist.bookname,booklist.anthorname,booklist.publication,booklist.type_id from booklist;

create profile liqingfeng_profile limit sessions_per_user 4 connect_time 60 idle_time 20;
lter user liqingfeng_user1 account unlock;
revoke connect from liqingfeng_user1;
drop user liqingfeng_user1;