Page History

Roles Roadmap

Environment:

1. Apply Oracle patch  5648872. This should fix the intermittent problems with the PowerBuilder application. (Rob G.)
2. Move roles db off of Solaris and onto Linux VMware
3. Migrate DB from ASCII to Unicode (UTF-8)
   

...

1. Program for defragmenting a qualifier type (qualifier_id number  ranges) This program is written and has been tested on the test Roles DB. It will be useful when qualifiers of a given type run out of their number  range of qualifier_ids.
   1. Things to be added:
      1. Make sure we have good documentation
      2. Spend a couple of hours to allow a different option, to support  moving qualifier IDs to a different range
2. Expand qualifier code character limit from 15 characters to 64?
   1. Are there stored procedures or feed programs that examine the length of the qualifier code?
      1. Identify the stored procedures that would need updating
   2. Are there applications receiving data that will break if they encounter a qualifier code longer than 15 characters?
      1. Should we try to take an inventory? Or should we create a new view that would filter out codes longer than 15 characters?
3. Minor enhancements to nightly data feed program for implied Authorizations (The nightly data feed program extauth.pm needs some minor Enhancements to support Function_groups in rule types 1a and 1b)
4. Add a UI or improve documentation for qualifier sub-types and Related configuration tables (There is no UI for defining qualifier "sub-types" and links to other object types.  Qualifier sub-types definitions are needed for some rule types. Consider either expanding the documentation to better explain this, or write a simple UI to maintain the additional configuration tables, or both.)
5. Adding web service methods for Qualifier maintenance
   1. Check to see if existing stored procedures are sufficient to support web service "wrappers", or if some enhancements need to be done for server and end-user level authorization checking
6. Qualifier maintenance
   1. Exploration of moving to real-time qualifier maintenance rather than batch feeds.  Could use existing stored procedures for new web services, but we might want to enhance the stored procedures to update links in primary_auth_descendent table
7. Improved qualifier schemas - better support for qualifier sub-types (rather than pattern matching of qualifier_codes used in current rules support) and better integration with Master Department 
   Hierarchy
8. The existing four rule types support requirements for EHS and  Library, but could be made much more powerful if we allowed for  "composite" rules, i.e., rules that "and" together two or more rules of existing types (e.g., you get this implied authorization if two different rule conditions both fit)
9. Bug fix: Roles Web UI: Allow searching on two character last names. (in progress, 9/2/2010)
10. Bug fix: Roles Web UI: Problems with HR functions which have ampersands in them.  
    

    Documentation:

    
    
11.  Knowledge  transfer / documentation?
12. The "ROLES / SAP R/3 PD Org Feed" report Should we improve the output of the report so that it is meaningful to more people?
13. Do we need more documentation about rule maintenance in general?
    

    Misc:

    
    
14. Release source to permit (in progress, 9/7/2010)
    1. Marilyn Smith and Steve Buckley have given the go ahead. Pat has provided Paul Hill with the links to the process that must be followed.
    2. Paul Heffernan has been assigned to this task.
15. accommodate a "2nd qualifier" for some HR authorizations
    1. The use case needs to written up and a review of alternate ways to support the use case  should be examined.