oracle创建用户授权命令

grant administer any sql tuning set to db_zhang;
grant administer database trigger to db_zhang;
begin
dbms_resource_manager_privs.grant_system_privilege(
grantee_name => 'db_zhang',
privilege_name => 'administer_resource_manager',
admin_option => false);
end;
/
grant administer sql management object to db_zhang;
grant administer sql tuning set to db_zhang;
grant advisor to db_zhang;
grant alter any assembly to db_zhang;
grant alter any cluster to db_zhang;
grant alter any cube to db_zhang;
grant alter any cube dimension to db_zhang;
grant alter any dimension to db_zhang;
grant alter any edition to db_zhang;
grant alter any evaluation context to db_zhang;
grant alter any index to db_zhang;
grant alter any indextype to db_zhang;
grant alter any library to db_zhang;
grant alter any materialized view to db_zhang;
grant alter any mining model to db_zhang;
grant alter any operator to db_zhang;
grant alter any outline to db_zhang;
grant alter any procedure to db_zhang;
grant alter any role to db_zhang;
grant alter any rule to db_zhang;
grant alter any rule set to db_zhang;
grant alter any sequence to db_zhang;
grant alter any sql profile to db_zhang;
grant alter any table to db_zhang;
grant alter any trigger to db_zhang;
grant alter any type to db_zhang;
grant alter database to db_zhang;
grant alter profile to db_zhang;
grant alter resource cost to db_zhang;
grant alter rollback segment to db_zhang;
grant alter session to db_zhang;
grant alter system to db_zhang;
grant alter tablespace to db_zhang;
grant alter user to db_zhang;
grant analyze any to db_zhang;
grant audit any to db_zhang;
grant audit system to db_zhang;
grant backup any table to db_zhang;
grant become user to db_zhang;
grant change notification to db_zhang;
grant comment any mining model to db_zhang;
grant comment any table to db_zhang;
grant create any assembly to db_zhang;
grant create any cluster to db_zhang;
grant create any context to db_zhang;
grant create any cube to db_zhang;
grant create any cube build process to db_zhang;
grant create any cube dimension to db_zhang;
grant create any dimension to db_zhang;
grant create any directory to db_zhang;
grant create any edition to db_zhang;
grant create any evaluation context to db_zhang;
grant create any index to db_zhang;
grant create any indextype to db_zhang;
grant create any job to db_zhang;
grant create any library to db_zhang;
grant create any materialized view to db_zhang;
grant create any measure folder to db_zhang;
grant create any mining model to db_zhang;
grant create any operator to db_zhang;
grant create any outline to db_zhang;
grant create any procedure to db_zhang;
grant create any rule to db_zhang;
grant create any rule set to db_zhang;
grant create any sequence to db_zhang;
grant create any sql profile to db_zhang;
grant create any synonym to db_zhang;
grant create any table to db_zhang;
grant create any trigger to db_zhang;

grant create any type to db_zhang;
grant create any view to db_zhang;
grant create assembly to db_zhang;
grant create cluster to db_zhang;
grant create cube to db_zhang;
grant create cube build process to db_zhang;
grant create cube dimension to db_zhang;
grant create database link to db_zhang;
grant create dimension to db_zhang;
grant create evaluation context to db_zhang;
grant create external job to db_zhang;
grant create indextype to db_zhang;
grant create job to db_zhang;
grant create library to db_zhang;
grant create materialized view to db_zhang;
grant create measure folder to db_zhang;
grant create mining model to db_zhang;
grant create operator to db_zhang;
grant create procedure to db_zhang;
grant create profile to db_zhang;
grant create public database link to db_zhang;
grant create public synonym to db_zhang;
grant create role to db_zhang;
grant create rollback segment to db_zhang;
grant create rule to db_zhang;
grant create rule set to db_zhang;
grant create sequence to db_zhang;
grant create session to db_zhang;
grant create synonym to db_zhang;
grant create table to db_zhang;
grant create tablespace to db_zhang;
grant create trigger to db_zhang;
grant create type to db_zhang;
grant create user to db_zhang;
grant create view to db_zhang;
grant debug any procedure to db_zhang;
grant debug connect session to db_zhang;
grant delete any cube dimension to db_zhang;
grant delete any measure folder to db_zhang;
grant delete any table to db_zhang;
grant dequeue any queue to db_zhang;
grant drop any assembly to db_zhang;
grant drop any cluster to db_zhang;
grant drop any context to db_zhang;
grant drop any cube to db_zhang;
grant drop any cube build process to db_zhang;
grant drop any cube dimension to db_zhang;
grant drop any dimension to db_zhang;
grant drop any directory to db_zhang;
grant drop any edition to db_zhang;
grant drop any evaluation context to db_zhang;
grant drop any index to db_zhang;
grant drop any indextype to db_zhang;
grant drop any library to db_zhang;
grant drop any materialized view to db_zhang;
grant drop any measure folder to db_zhang;
grant drop any mining model to db_zhang;
grant drop any operator to db_zhang;
grant drop any outline to db_zhang;
grant drop any procedure to db_zhang;
grant drop any role to db_zhang;
grant drop any rule to db_zhang;
grant drop any rule set to db_zhang;
grant drop any sequence to db_zhang;
grant drop any sql profile to db_zhang;
grant drop any synonym to db_zhang;
grant drop any table to db_zhang;
grant drop any trigger to db_zhang;
grant drop any type to db_zhang;
grant drop any view to db_zhang;
grant drop profile to db_zhang;
grant drop public database link to db_zhang;
grant drop public synonym to db_zhang;
grant drop rollback segment to db_zhang;
grant drop tablespace to db_zhang;
grant drop user to db_zhang;
grant enqueue any queue to db_zhang;
grant execute any assembly to db_zhang;
grant execute an

y class to db_zhang;
grant execute any evaluation context to db_zhang;
grant execute any indextype to db_zhang;
grant execute any library to db_zhang;
grant execute any operator to db_zhang;
grant execute any procedure to db_zhang;
grant execute any program to db_zhang;
grant execute any rule to db_zhang;
grant execute any rule set to db_zhang;
grant execute any type to db_zhang;
grant execute assembly to db_zhang;
grant export full database to db_zhang;
grant flashback any table to db_zhang;
grant flashback archive administer to db_zhang;
grant force any transaction to db_zhang;
grant force transaction to db_zhang;
grant global query rewrite to db_zhang;
grant grant any object privilege to db_zhang;
grant grant any privilege to db_zhang;
grant grant any role to db_zhang;
grant import full database to db_zhang;
grant insert any cube dimension to db_zhang;
grant insert any measure folder to db_zhang;
grant insert any table to db_zhang;
grant lock any table to db_zhang;
grant manage any file group to db_zhang;
grant manage any queue to db_zhang;
grant manage file group to db_zhang;
grant manage scheduler to db_zhang;
grant manage tablespace to db_zhang;
grant merge any view to db_zhang;
grant on commit refresh to db_zhang;
grant query rewrite to db_zhang;
grant read any file group to db_zhang;
grant restricted session to db_zhang;
grant resumable to db_zhang;
grant select any cube to db_zhang;
grant select any cube dimension to db_zhang;
grant select any mining model to db_zhang;
grant select any sequence to db_zhang;
grant select any table to db_zhang;
grant select any transaction to db_zhang;
grant under any table to db_zhang;
grant under any type to db_zhang;
grant under any view to db_zhang;
grant unlimited tablespace to db_zhang;
grant update any cube to db_zhang;
grant update any cube build process to db_zhang;
grant update any cube dimension to db_zhang;
grant update any table to db_zhang;