oracle 将a用户权限赋给b用户

王朝oracle·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

也是从CSDN上找来的.....

1).logon as grantor, for instance USER1

2). run PL/SQL scripts:

DECLARE

p_grantee VARCHAR2(30):='ywxt_module_admin';

BEGIN

FOR rec IN (SELECT object_name, object_type

, DECODE (object_type, 'TABLE', 'ALL', 'VIEW', 'SELECT', 'EXECUTE') grant_type FROM user_objects)

LOOP

BEGIN

EXECUTE IMMEDIATE 'grant all on ' || rec.object_name || ' to ' || p_grantee;

EXCEPTION

WHEN OTHERS THEN

DBMS_OUTPUT.PUT_LINE(SUBSTR (SQLERRM,1,240));

END;

END LOOP;

END;

/

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航