µ±Ç°Î»ÖãºLinux½Ì³Ì - Linux×ÊѶ - ¼ÓÃÜ´æ´¢¹ý³Ì,ÊÚÓÚÆäËüÓû§Ö´ÐÐ

¼ÓÃÜ´æ´¢¹ý³Ì,ÊÚÓÚÆäËüÓû§Ö´ÐÐ

¡¡¡¡Ëæ×ÅÉç»áµÄ·Ö¹¤ÓëºÏ×÷Ô½À´Ô½ÃÜÇУ¬Í¬Ò»Ì¨·þÎñÆ÷Àï¿ÉÄÜ»áÔËÐм¸¼Ò¹«Ë¾²»Í¬µÄ·þÎñ²úÆ·£¬¡¡¡¡¡¡¡¡ÓÐʱºò·þÎñÖ®¼äÐèÒª»¥ÏàÌṩÊý¾Ý£¬ÒÔʵÏÖ¾­¼ÃÉϵÄË«Ó®£»µ±È»¸÷×ԵݲȫºÍ¶ÀÁ¢ÐÔÒ²ÐèÒª±£Ö¤¡£¡¡¡¡¡¡¡¡Èç¹ûÕâÑùµÄ·þÎñºǫ́ÓõÄÊÇOracleÊý¾Ý¿â£¬¿ÉÒÔÓüÓÃÜ´æ´¢¹ý³Ì£¬²¢ÊÚÓÚÆäËüÓû§Ö´Ðеķ½·¨¡£¡¡¡¡¡¡¡¡Ê×ÏÈÎÒÃÇҪΪÌṩµÄÊý¾Ýдһ¸öÕýÈ·ºÏºõÂß¼­µÄ´æ´¢¹ý³Ì»òº¯Êýtest_proc£¬¼ÙÉèÔ´´úÂëÊÇtest.sql¡£¡¡¡¡¡¡¡¡È»ºóÓÃwrapʵÓù¤¾ß(ĬÈϵÄĿ¼$ORACLE_HOME/bin)¼ÓÃÜËü£º¡¡¡¡¡¡¡¡Ê¹ÓÃwrapµÄÓï·¨ÊÇ:¡¡¡¡¡¡¡¡$wrap iname =¡¡input_file¡¡¡¡¡¡¡¡¡¡[oname=output_file]¡¡¡¡¡ü¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ ¡ü¡¡¡¡¼ÓÃÜÇ°´æ´¢¹ý³Ì»òº¯Êý¡¡¼ÓÃܺó´æ´¢¹ý³Ì»òº¯Êý,ĬÈϵĺó׺Ϊ*.plb¡¡¡¡¡¡¡¡¾ÙÀý£º¡¡$wrap iname=test.sql¡¡¡¡¡¡¡¡»áÔÚµ±Ç°Ä¿Â¼²úÉútest.plb¼ÓÃܵĴ洢¹ý³Ì»òº¯Êý¡¡¡¡¡¡¡¡±¸×¢£º¡¡WindowsºÍunixƽ̨µÄÏÂwrapÉú³É*.plb¼ÓÃÜÎļþ¿ÉÒÔͨÓ㬰汾ÊÇÏòÉϼæÈݵġ£¡¡¡¡¡¡¡¡×îºó±àÒëÕâ¸ö¼ÓÃܺóµÄtest.plb¡¡¡¡¡¡¡¡SQL> @/tmp/test.plb¡¡¡¡¡¡¡¡²¢¸³ÓÚÏà¹ØºÏ×÷Óû§(another_user)Ö´ÐеÄȨÏÞ¡¡¡¡¡¡¡¡SQL> grant execute on test_proc to another_user;¡¡¡¡¡¡¡¡ÆäËüµÄ×¢ÒâÊÂÏ¡¡¡¡¡¡¡¡ºÏ×÷Óû§²»ÄÜÓйý¶àµÄȨÏÞ, ʹËûÃDz»ÄܲéÊý¾Ý×ÖµäºÍÆäËüÓû§ÏÂµÄ±í£¬ÃÜÂëÒªÆðµÃÄÑһЩ¡£

£¨³ö´¦£ºhttp://www.sheup.com£©