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 DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
Ò»¡¢Ê²Ã´ÊÇoracle×Ö·û¼¯
¡¡¡¡Oracle×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ºÏ,ÓдóС֮·Ö,ÓÐÏ໥µÄ°üÈݹØÏµ¡£ORACLE Ö§³Ö¹ú¼ÒÓïÑÔµÄÌåϵ½á¹¹ÔÊÐíÄãʹÓñ¾µØ»¯ÓïÑÔÀ´´æ´¢£¬´¦Àí£¬¼ìË÷Êý¾Ý¡£ËüʹÊý¾Ý¿â¹¤¾ß£¬´íÎóÏûÏ¢£¬ÅÅÐò´ÎÐò£¬ÈÕÆÚ£¬Ê±¼ä£¬»õ±Ò£¬Êý×Ö£¬ºÍÈÕÀú×Ô¶¯ÊÊÓ¦±¾µØ»¯ÓïÑÔºÍÆ½Ì¨¡£
SELECT * from V$NLS_PARAMETERS
......
ORACLEÖÐÊý¾Ý×ÖµäÊÓͼ·ÖΪ3´óÀà, ÓÃÇ°×ºÇø±ð£¬·Ö±ðΪ£ºUSER£¬ALL ºÍ DBA£¬Ðí¶àÊý¾Ý×ÖµäÊÓͼ°üº¬ÏàËÆµÄÐÅÏ¢¡£
USER_*:ÓйØÓû§ËùÓµÓеĶÔÏóÐÅÏ¢£¬¼´Óû§×Ô¼º´´½¨µÄ¶ÔÏóÐÅÏ¢
ALL_*£ºÓйØÓû§¿ÉÒÔ·ÃÎʵĶÔÏóµÄÐÅÏ¢£¬¼´Óû§×Ô¼º´´½¨µÄ¶ÔÏóµÄÐÅÏ¢¼ÓÉÏÆäËûÓû§´´½¨µÄ¶ÔÏ󵫸ÃÓû§ÓÐȨ·ÃÎʵÄÐÅÏ¢
DBA_* ......
Èç¹ûÄãÒª°ÑOracleÀïµÄ´óÁ¿Êý¾Ý(80MÒÔÉÏ)×ªÒÆµ½ÁíÍâµÄÓû§£¬ÁíÍâµÄ±í¿Õ¼äÀï¡£¿ÉÒÔÓÃÏÂÃæ½éÉܵĿìËÙ×ªÒÆÊý¾ÝµÄ·½·¨¡£
Ò»¡¢½¨Ð±íµÄ·½Ê½
create table target_tablename tablespace
target_tablespace_name nologging
pctfree 10 pctused 60
storage(initial 5M next 5M minextents 1
maxextents unlimited pctincr ......
ºÙºÙ£¬Õ⻹ÊÇÉÏÕÂ֪ʶÁË£¬Ö»Êǵ¥Ò»Ð´³öÀ´±È½ÏºÃÒ»µã£¬ÒòΪÉÏÃæµÄÊǽϻù´¡µÄ£¬²»ÔõÃ´Éæ¼°²Ù×÷£¬¶øÕâÀïÊÇͨ¹ý²Ù×÷³öÀ´µÄ£¬ºÇºÇ¡£
Ê×ÏÈ£¬´ò¿ªÊý¾Ý¿â·þÎñ£¬È»ºóͨ¹ý¿ØÖÆÌ¨´ò¿ªsqlplus£º
È»ºó½«Êý¾Ý¿âÉèÖÃΪֻ¶Á£ºalter database read only£»µ«ÊÇÄØ£¬ÕâÑùÊDz»Ä ......