也是从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;
/
一起学吧部分文章转载自互联网,供读者交流和学习,若有涉及作者版权等问题请及时与我们联系,以便更正、删除或按规定办理。感谢所有提供资讯的网站,欢迎各类媒体与一起学吧进行文章共享合作。