Oracle 数据库下赋予用户的执行存储过程和创建表权限
grant create any table to username;
grant create any procedure to username;
grant execute any procedure to username;
创建执行JOB权限:
grant create job to 用户;
grant manage scheduler to 用户;
给一个表的读取权限:
grant select on 表名 to 用户名;
删除修改权限 (alter 有 truncate 权限):
GRANT SELECT,INSERT,UPDATE,DELETE
GRANT SELECT,INSERT,UPDATE,DELETE,alter
删除读取所有表的权限:
Revoke select any table from 用户名;
赋予创建表的权限:
grant resource to common_user -- grant create table to common_user -- grant select any table to common_user;
获取某个用户下的全部表:
select 'grant select on '|| tname ||' to 用户名;' from tab where tname not like 'BIN%';
posted on 2020-01-05 20:50 morgan363 阅读(4671) 评论(0) 编辑 收藏 举报