Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle Workflows Access Protection Concepts

Oracle Workflows Access Protection Concepts
As a workflow developer, you can use access protection to allow or discourage “customers” of your workflows from modifying your “seed data” workflow definitions.
×÷Ϊ¹¤×÷Á÷¿ª·¢Õߣ¬Äã¿ÉÒÔÀûÓ÷ÃÎÊ¿ØÖƱ£»¤È¨ÏÞÀ´ÔÊÐí»ò×èÖ¹¹¤×÷Á÷µÄʹÓÃÕßÐÞ¸ÄÄã×îÖÕ
¶¨ÒåµÄ¹¤×÷Á÷¡£
As a customer of predefined workflows provided by Oracle, you can use access protection to preserve valid customizations you have made to a predefined workflow during a workflow definition upgrade.
×÷Ϊ¼×¹ÇÎÄÌṩµÄÔ¤¶¨Ò幤×÷Á÷£¬Äã¿ÉÒÔÀûÓ÷ÃÎÊ¿ØÖÆÈ¨ÏÞÀ´±£»¤Äã¶Ô¹¤×÷Á÷µÄÓÐЧµÄ¿Í»§»¯Éý¼¶¡£
All workflow objects except lookup codes, function attributes, and message attributes contain an Access tab in their property pages.  Lookup codes, function attributes, and message attributes inherit their access settings from their parent lookup type, function, or message, respectively.
³ýÁËLookup´úÂ룬º¯ÊýÊôÐÔºÍÏûÏ¢ÊôÐÔµÄÆäËûËùÓй¤×÷Á÷¶ÔÏó¶¼°üº¬¿ØÖÆÊôÐÔ±êǩҳ¡£Loopup£¬º¯ÊýÊôÐÔºÍÏûÏ¢ÊôÐÔ·Ö±ð¼Ì³ÐËüÃǸ¸ÀàÐ͵ķÃÎÊ¿ØÖÆÈ¨ÏÞ¡£
The Access tab lets you define whether:
•Future customizations to the object are preserved during a workflow definition upgrade.
•The object can be edited by users operating at a higher access level.
 ·ÃÎʱêÇ©¿ÉÒÔÈÃÄ㶨ÒåÊÇ·ñ£º
ÔÚ¹¤×÷Á÷Éý¼¶µÄʱºò£¬±£»¤Î´À´¾­¹ý¿Í»§»¯µÄ¶ÔÏó
¶ÔÏó¿ÉÒÔÔÚ¸ü¸ßµÄ·ÃÎʼ¶±ðÉϱ»±à¼­¡£
ACCESS LEVELS
·ÃÎʼ¶±ð
Each user of Oracle Workflow Builder operates the system at a certain access level.
The access levels are defined as follows:
ü       0-9: Reserved for Oracle Workflow
ü       10-19: Reserved for Oracle Application Object Library
ü       20-99: Reserved for Oracle E-Business Suite
ü       100-999: Reserved for customer organizations
ü       1000: Public
ÿ¸ö Oracle Workflow Builder µÄʹÓÃÕ


Ïà¹ØÎĵµ£º

ÐÞ¸ÄOracle XDBµÄ8080¶Ë¿Ú

´ÓOracle 9i¿ªÊ¼£¬OracleµÄ°²×°È±Ê¡°üº¬ÁËXDB¡£ÔÚÆô¶¯Êý¾Ý¿âºó£¬Oracle XDBµÄhttp·þÎñ½«»á×Ô¶¯Õ¼ÓÃÁË8080¶Ë¿Ú£¬Õâ¸øÊ¹ÓûòJBoss¡¢Tomcat½øÐÐjava web¿ª·¢µÄÈËÔì³ÉÁËÐí¶à²»±ØÒªµÄÂé·³¡£
±¾ÎĽ«Ö÷Òª½éÉÜÐÞ¸ÄXDBµÄhttpºÍftp·þÎñ¶Ë¿ÚµÄ3ÖÖ·½·¨¡£
1.ʹÓÃdbms_xdb°üÐ޸Ķ˿ÚÉèÖÃ
ʹÓÃsysµÇ¼sqlplus
sqlplus sys/password ......

oracleÓÅ»¯

ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£©Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
orACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ, ......

oracleÖÐblock

°´×ÊÁÏ˵V$BH²é¿´±íÀ´ÏÔʾÊý¾Ý¿âÀïÿ¸ö¶ÔÏóÀàÐ͵ÄÊý¾Ý»º³åÇøÀïÊý¾Ý¿éµÄÊýÁ¿.
È»ºó²éѯV$bh
select
   owner, object_name                 
  from
   dba_objects o,
   v$bh      &nbs ......

110¸öoracle³£Óú¯Êý×ܽá

1. ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2. CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH C
-- -
ÕÔ A
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ