赋予oracle执行存储过程权限和创建表权限

grant create any table to username;
grant create any procedure to username; grant execute any procedure to username;

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 create job to 用户; grant manage scheduler to 用户;

给一个表的读取权限

grant select on 表名 to 用户名;

grant select on 表名 to 用户名;

删除修改权限 alter是有truncate权限

GRANT SELECT,INSERT,UPDATE,DELETE GRANT SELECT,INSERT,UPDATE,DELETE,alter

GRANT SELECT,INSERT,UPDATE,DELETE GRANT SELECT,INSERT,UPDATE,DELETE,alter

删除读取所有表的权限

Revoke select any table from 用户名;

Revoke select any table from 用户名;

创建表权限

grant resource to common_user

-- grant create table to common_user
-- grant select any table to common_user;

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%;

select grant select on || tname || to 用户名; from tab where tname not like BIN%;

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%;