OracleÓû§¡¢È¨ÏÞ¡¢½ÇÉ«¹ÜÀí
OracleÓû§¡¢È¨ÏÞ¡¢½ÇÉ«¹ÜÀí
Oracle ȨÏÞÉèÖÃ
Ò»¡¢È¨ÏÞ·ÖÀࣺ
ϵͳȨÏÞ£ºÏµÍ³¹æ¶¨Óû§Ê¹ÓÃÊý¾Ý¿âµÄȨÏÞ¡££¨ÏµÍ³È¨ÏÞÊǶÔÓû§¶øÑÔ)¡£
ʵÌåȨÏÞ£ºÄ³ÖÖȨÏÞÓû§¶ÔÆäËüÓû§µÄ±í»òÊÓͼµÄ´æÈ¡È¨ÏÞ¡££¨ÊÇÕë¶Ô±í»òÊÓͼ¶øÑԵģ©¡£
¶þ¡¢ÏµÍ³È¨ÏÞ¹ÜÀí£º
1¡¢ÏµÍ³È¨ÏÞ·ÖÀࣺ
DBA: ÓµÓÐÈ«²¿ÌØÈ¨£¬ÊÇϵͳ×î¸ßȨÏÞ£¬Ö»ÓÐDBA²Å¿ÉÒÔ´´½¨Êý¾Ý¿â½á¹¹¡£
RESOURCE:ÓµÓÐResourceȨÏÞµÄÓû§Ö»¿ÉÒÔ´´½¨ÊµÌ壬²»¿ÉÒÔ´´½¨Êý¾Ý¿â½á¹¹¡£
CONNECT:ÓµÓÐConnectȨÏÞµÄÓû§Ö»¿ÉÒԵǼOracle£¬²»¿ÉÒÔ´´½¨ÊµÌ壬²»¿ÉÒÔ´´½¨Êý¾Ý¿â½á¹¹¡£
¶ÔÓÚÆÕͨÓû§£ºÊÚÓèconnect, resourceȨÏÞ¡£
¶ÔÓÚDBA¹ÜÀíÓû§£ºÊÚÓèconnect£¬resource, dbaȨÏÞ¡£
2¡¢ÏµÍ³È¨ÏÞÊÚȨÃüÁ
[ϵͳȨÏÞÖ»ÄÜÓÉDBAÓû§ÊÚ³ö£ºsys, system(×ʼֻÄÜÊÇÕâÁ½¸öÓû§)]
ÊÚȨÃüÁSQL> grant connect, resource, dba to Óû§Ãû1 [,Óû§Ãû2]...;
[ÆÕͨÓû§Í¨¹ýÊÚȨ¿ÉÒÔ¾ßÓÐÓësystemÏàͬµÄÓû§È¨ÏÞ£¬µ«ÓÀÔ¶²»ÄÜ´ïµ½ÓësysÓû§ÏàͬµÄȨÏÞ£¬systemÓû§µÄȨÏÞÒ²¿ÉÒÔ±»»ØÊÕ¡£]
Àý£º
SQL> connect system/manager
SQL> Create user user50 identified by user50;
SQL> grant connect, resource to user50;
²éѯÓû§ÓµÓÐÄÄÀïȨÏÞ£º
SQL> select * from dba_role_privs;
SQL> select * from dba_sys_privs;
SQL> select * from role_sys_privs;
ɾ³ýÓû§£ºSQL> drop user Óû§Ãû cascade; //¼ÓÉÏcascadeÔò½«Óû§Á¬Í¬Æä´´½¨µÄ¶«Î÷È«²¿É¾³ý
3¡¢ÏµÍ³È¨ÏÞ´«µÝ£º
Ôö¼ÓWITH ADMIN OPTIONÑ¡ÏÔòµÃµ½µÄȨÏÞ¿ÉÒÔ´«µÝ¡£
SQL> grant connect, resorce to user50 with admin option; //¿ÉÒÔ´«µÝËù»ñȨÏÞ¡£
4¡¢ÏµÍ³È¨ÏÞ»ØÊÕ£ºÏµÍ³È¨ÏÞÖ»ÄÜÓÉDBAÓû§»ØÊÕ
ÃüÁSQL> Revoke connect, resource from user50;
˵Ã÷£º
1£©Èç¹ûʹÓÃWITH ADMIN OPTIONΪij¸öÓû§ÊÚÓèϵͳȨÏÞ£¬ÄÇô¶ÔÓÚ±»Õâ¸öÓû§ÊÚÓèÏàͬȨÏÞµÄËùÓÐÓû§À´Ëµ£¬È¡Ïû¸ÃÓû§µÄϵͳȨÏÞ²¢²»»á¼¶ÁªÈ¡ÏûÕâЩÓû§µÄÏàͬȨÏÞ¡£
2£©ÏµÍ³È¨ÏÞÎÞ¼¶Áª£¬¼´AÊÚÓèBȨÏÞ£¬BÊÚÓèCȨÏÞ£¬Èç¹ûAÊÕ»ØBµÄȨÏÞ£¬CµÄȨÏÞ²»ÊÜÓ°Ï죻ϵͳȨÏÞ¿ÉÒÔ¿çÓû§»ØÊÕ£¬¼´A¿ÉÒÔÖ±½ÓÊÕ»ØCÓû§µÄȨÏÞ¡£
Èý¡¢ÊµÌåȨÏÞ¹ÜÀí
1¡¢ÊµÌåȨÏÞ·ÖÀࣺselect, update, insert, alter, index, delete, all //all°üÀ¨ËùÓÐȨÏÞ
execute //Ö´Ðд洢¹ý³ÌȨÏÞ
user01:
SQL> grant select, update, insert on product to user02;
SQL> grant all o
Ïà¹ØÎĵµ£º
1. È¡A±íµÄÊý¾Ý£¬¸üÐÂB±í×Ö¶Î
update m_build b
set b.district_id=(
select d.district_id
from
bjhouse.d_district d
where
b.build_name_jq=d.district_name)
where exists
(select 1
from ......
ÎÒÃÇ´ó¼Ò¶¼ÖªµÀÿ¸öOracleÊý¾Ý¿â¶¼»áÓÐÒ»¸ö»òÊǶà¸öÎïÀíµÄOracleÊý¾ÝÎļþ,Êý¾Ý¿âÐÅÏ¢(½á¹¹,Êý¾Ý)µÄÖ÷Òª×÷ÓÃÊÇÀ´±£´æÔÚÕâЩÏà¹ØµÄÊý¾ÝÎļþ,¶øÇÒÖ»ÓÐÕâЩÏà¹ØµÄÎļþOracle²ÅÄܹ»½âÊÍÓë¹ÜÀíÕâЩ´æ´¢.OracleÊý¾ÝÎļþ¾ßÓÐÒÔÏÂÒ»Ð©ÌØÐÔ:
1.Ò»¸öÊý¾ÝÎļþ½ö½ö¹ØÁªÒ»¸öÊý¾Ý¿â,OracleÊý¾ÝÎļþÓëÊý¾Ý¿âÖ®¼ä¶ÔÓ¦¹ØÏµÊÇÒ»¶ÔÒ»¹ØÏµ,µ±È»· ......
½üÀ´½ÓÁ˸ö¼òµ¥µÄϵͳ×ö£¬Íâ°üµÄ£¬ÓõÄÊý¾Ý¿âÊÇoracle8i,
Ò»¿ªÊ¼ÎÒʹÓà ojdbc6.jarÀ´×öÁ¬½Ó£¬Á¬²»ÉÏ£¬ÕÒÒ»·¬£¬ÔÀ´¹Ù·½oracle8i³öµÄÇý¶¯Ö»ÓÐ class12.jar ºÍclass14.jar ,×îÒªÃüµÄÊDz»Ö§³Öjdk1.4¼°1.4ÒÔÉϵ쬹¤×÷Á¿ÂíÉϾÍÉÏÀ´ÁË¡£²»¸ÊÐİ¡¡£
×îºóÊÔÁËÏ£¬ÄÜÓõÄÖ»ÓÐojadb14.jar £¬Á¬ÉÏÁË£¬²»¹ýͨ¹ýhibernateÉú³ÉµÄsqlÊµÔ ......
¸Õ¸Õ½Ó´¥ORACLEµÄÈËÀ´Ëµ,´ÓÄÇÀïѧ,ÈçºÎѧ,ÓÐÄÇЩ¹¤¾ß¿ÉÒÔʹÓÃ,Ó¦¸ÃÖ´ÐÐʲô²Ù×÷,Ò»¶¨»Ø¸Ðµ½ÎÞÖú¡£ËùÒÔÔÚѧϰʹÓÃORACLE֮ǰ£¬Ê×ÏÈÀ´°²×°Ò»ÏÂORACLE 10g£¬ÔÚÀ´ÕÆÎÕÆä»ù±¾¹¤¾ß¡£Ë×»°ËµµÄºÃ£º¹¤ÓûÉÆÆäÊ£¬±ØÏÈÀûÆäÆ÷¡£ÎÒÃÇ¿ªÊ¼°É£¡
¡¡¡¡Ê×ÏȽ«ORACLE 10gµÄ°²×°¹âÅÌ·ÅÈë¹âÇý£¬Èç¹û×Ô¶¯ÔËÐУ¬Ò»°ã»á³öÏÖÈçͼ1°²×°½çÃæ£º
ͼ1
......
רÓÐģʽ£º
ÔÚרÓзþÎñÆ÷ÅäÖÃÖУ¬OracleΪÿ¸öÁ¬½Óµ½·þÎñÆ÷µÃ¿Í»§»úÆô¶¯Ò»¸öרÓ÷þÎñÆ÷½ø³Ì¡£Ò»¸ö¿Í»§»úµÄרÓ÷þÎñÆ÷½ø³ÌֻΪ´Ë¿Í»§»ú¹¤×÷¡£¸÷רÓ÷þÎñÆ÷½ø³ÌÍêÈ«¶ÀÁ¢£¬ÎÞÐè¹²ÏíÊý¾Ý¡£ÔÚÓû§»á»°´æÔÚµÄÕû¸ö¹ý³ÌÖУ¬ÏàÓ¦µÄרÓ÷þÎñÆ÷½ø³ÌÒ»Ö±´æÔÚ£¬²»ÂÛÓû§ÊÇ·ñ»î¶¯¡£Ö±µ½Óû§»á»°ÖÕÖ¹ºó£¬¸ÃÓ¦ÓõÄרÓ÷þÎñÆ÷½ø³Ì²ÅÖÕÖ¹¡£ÔÚ ......