oracle ¶ÔÏóµÄÊÚȨ
Gold Country
OracleÊÚȨ
Ò»¡¢ÊÚȨÓï·¨
GRANT Óï·¨£º
1.ÏÔʽÊÚȨ(Ö±½Ó½«¶ÔÏóÊÚȨ¸øÓû§)
GRANT privilege [, ...] ON object [, ...] TO { Public| Group | Username|role} [WITH GRANT OPTION ]
2.ÒþʽÊÚȨ(ͨ¹ý½«½ÇÉ«ÊÚȨ¸øÓû§)
GRANT role TO { Public| Group | Username|role}
Ó﷨˵Ã÷£º
privilege (ȨÏÞ)
¿ÉÄܵÄȨÏÞÓУº
SELECT--·ÃÎÊÉùÃ÷µÄ±í/ÊÓͼµÄËùÓÐÁÐ/×ֶΣ®
INSERT--ÏòÉùÃ÷µÄ±íÖвåÈëËùÓÐÁÐ×ֶΣ®
UPDATE--¸üÐÂÉùÃ÷µÄËùÓÐÁÐ/×ֶΣ®
DELETE --´ÓÉùÃ÷µÄ±íÖÐɾ³ýËùÓÐÐУ®
RULE ÔÚ±í/ÊÓͼÉ϶¨Ò广Ôò £¨²Î¼û CREATE RULE Óï¾ä£©£®
ALL ¸³ÓèËùÓÐȨÏÞ£®
object ¸³ÓèȨÏ޵ĶÔÏóÃû£®
¿ÉÄܵĶÔÏóÊÇ£º
table £¨±í£©
view £¨ÊÓͼ£©
sequence £¨ÐòÁУ©
index £¨Ë÷Òý£©
Public ´ú±íÊÇËùÓÐÓû§µÄ¼òд£®
Group ½«Òª¸³ÓèȨÏÞµÄ×éGROUP £®Ä¿Ç°µÄ°æ±¾ÖУ¬×鱨ÐëÊÇÓÃÏÂÃæ·½·¨ÏÔʽ´´½¨µÄ£®
Username ½«Òª¸³ÓèȨÏÞµÄÓû§Ãû£®PUBLIC ÊÇ´ú±íËùÓÐÓû§µÄ¼òд£®
role ij¸ö½ÇÉ«£¬(ÈçDBA)
WITH GRANT OPTION ÔÊÐíÏò±ðÈ˸³ÓèͬÑùȨÏÞ,±»ÊÚȨµÄÓû§¿ÉÒÔ¼ÌÐøÊÚȨ.
ÃèÊö
¶ÔÏó´´½¨ºó£¬³ýÁË´´½¨ÕßÍ⣬³ý·Ç´´½¨Õ߸³Ó裨GRANT£©È¨ÏÞ£¬ÆäËûÈËûÓзÃÎʶÔÏóµÄȨÏÞ¡£
GRANT ÔÊÐí¶ÔÏóµÄ´´½¨Õ߸øÄ³Óû§»òij×é»òËùÓÐÓû§£¨PUBLIC£©Ä³Ð©Ìض¨µÄȨÏÞ¡£²»ÐèÒª¸ø´´½¨Õ߸³Ó裨GRANT£©¶ÔÏóµÄȨÏÞ£¬´´½¨Õß×Ô¶¯ÓµÓжÔÏóµÄËùÓÐȨÏÞ£¬°üÀ¨É¾³ýËüµÄȨÏÞ¡£
˵Ã÷
Oracle²»ÔÊÐíÔÚ¹ý³ÌÖÐʹÓÃδ¾ÏÔʽÊÚȨµÄ¶ÔÏó. ҪʹÓÃÁíÒ»Óû§µÄ¶ÔÏ󣬱ØÐëͨ¹ýÁíÒ»Óû§¸ø×Ô¼ºÏÔʾÊÚȨ¡£
ÒòΪOracleÔÚ±àÒë´æ´¢¹ý³Ìʱ²¢²»¼ì²é¶¨ÒåÕßÓµÓеĽÇÉ«£¬Ö»ÊǼì²éÆä±»ÏÔʽÊÚÓèµÄȨÏÞ£¬¶øDBAÒ²ÊÇÒ»ÖÖ½ÇÉ«£¬ËùÒÔ¼´Ê¹ÊÇDBA£¬Ò²ÐèÒªÏÔʽÊÚȨ¡£
¶þ¡¢ÊÚȨ·½Ê½ (ÏÔʽºÍÒþʽ)
¶ÔÏóÊÚȨÓÐÁ½ÖÖģʽ,ÏÔʽºÍÒþʽ:
ÏÔʾÊÚȨºÍÒþʽÊÚȨµÄÇø±ðÊÇ£ºÏÔʾÊÚȨÊÇÖ±½Ó°Ñ¶ÔÏóÊÚȨ¸øÓû§£¬ÒþʽÊÚ
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
²½Ö裺
1.Ê×ÏÈ£¬ÄãÒªÓÐÒ»ÕÅ±í£¡
CREATE TABLE example(
ID Number(4) NOT NULL PRIMARY KEY,
NAME VARCHA ......
µ±ÄãÔÚÊý¾Ý¿âÖд´½¨Êý¾Ý±íµÄʱºò£¬ÄãÐèÒª¶¨Òå±íÖÐËùÓÐ×ֶεÄÀàÐÍ¡£ORACLEÓÐÐí¶àÖÖÊý¾ÝÀàÐÍÒÔÂú×ãÄãµÄÐèÒª¡£Êý¾ÝÀàÐÍ´óÔ¼·ÖΪ£ºcharacter, number, date, LOB, ºÍRAWµÈÀàÐÍ¡£ËäÈ»ORACLE8iÒ²ÔÊÐíÄã×Ô¶¨ÒåÊý¾ÝÀàÐÍ£¬µ«ÊÇËüÃÇÊÇ×î»ù±¾µÄÊý¾ÝÀàÐÍ¡£
ÔÚÏÂÃæµÄÎÄÕÂÖÐÄ㽫Á˽⵽ËûÃÇÔÚoracle ÖеÄÓ÷¨¡¢ÏÞÖÆÒÔ¼°ÔÊÐíÖµ¡£
¡¡¡¡
......
SQL> select * from emp where sal=800;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- ----- ......
. ´´½¨job
jobÊÇÊ²Ã´ÄØ? ¼òµ¥µÄ˵¾ÍÊǼƻ®(schedule)¼ÓÉÏÈÎÎñ˵Ã÷. ÁíÍ⻹ÓÐһЩ±ØÐëµÄ²ÎÊý.
ÕâÀïÌáµ½µÄ"ÈÎÎñ"¿ÉÒÔÊÇÊý¾Ý¿âÄÚ²¿µÄ´æ´¢¹ý³Ì,ÄäÃûµÄPL/SQL¿é,Ò²¿ÉÒÔÊDzÙ×÷ϵͳ¼¶±ðµÄ½Å±¾.
¿ÉÒÔÓÐÁ½ÖÖ·½Ê½À´¶¨Òå"¼Æ»®":
1) ʹÓÃDBMS_SCHDULER.CREATE_SCHEDULE ¶¨ÒåÒ»¸ö¼Æ»®;
2) µ÷ÓÃDBMS_SCHDULER.CREATE_JOBE¹ý³ÌÖ±½ÓÖ¸¶ ......