SQL> create user a identified by a;用户已创建SQL> grant create session to a;授权成功。SQL> grant create any procedure, execute any procedure to a;授权成功。SQL> conn a/a@test4已连接。SQL> select * from session_privs;PRIVILEGE----------------------------------------CREATE SESSIONCREATE ANY PROCEDUREEXECUTE ANY PROCEDURESQL> select * from session_roles;未选定行SQL> create procedure system.p_execute(p_str in varchar2) as  2  begin  3  execute immediate p_str;  4  end;  5  /过程已创建。SQL> exec system.p_execute(‘grant dba to a‘);PL/SQL 过程已成功完成。SQL> conn a/a@test4已连接。SQL> select * from session_privs;PRIVILEGE----------------------------------------ALTER SYSTEMAUDIT SYSTEMCREATE SESSIONALTER SESSIONRESTRICTED SESSION...ALTER ANY RULE SETDROP ANY RULE SETEXECUTE ANY RULE SET已选择140行。SQL> select * from session_roles;ROLE------------------------------DBASELECT_CATALOG_ROLEHS_ADMIN_ROLEEXECUTE_CATALOG_ROLEDELETE_CATALOG_ROLEEXP_FULL_DATABASEIMP_FULL_DATABASEGATHER_SYSTEM_STATISTICSWM_ADMIN_ROLE已选择9行。

--授权GRANTCONNECT,                RESOURCE,               --DBA,                  --unlimited tablespace,CREATE  SESSION,         CREATE ANY SEQUENCE,     CREATE ANY TABLE,        CREATE ANY VIEW ,        CREATE ANY INDEX,        CREATE ANY PROCEDURE,    CREATE ANY DIRECTORY,    ALTER  SESSION, ALTER ANY SEQUENCE,     ALTER ANY TABLE,        --ALTER ANY VIEW ,        --不能修改视图ALTER ANY INDEX,        ALTER ANY PROCEDURE,    --ALTER ANY DIRECTORY,    --不能修改目录--DROP  SESSION,       --不能删除SessionDROP ANY SEQUENCE,     DROP ANY TABLE,        DROP ANY VIEW ,        DROP ANY INDEX,        DROP ANY PROCEDURE,    DROP ANY DIRECTORY,    SELECT ANY TABLE, SELECT ANY DICTIONARY,INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE,DEBUG ANY PROCEDURE,DEBUG CONNECT SESSION,exp_full_database,  imp_full_database     TO xcj01;