Database system and method for access control and workflow routing

A method for use with a database management system to determine one or more next pages that may be reached:

• providing a process_process_links table that includes a from page name, a page name and a view name;
• providing a log roles structure that associates a role name with a transaction identifier associated with a page context;
• providing a role views table that provides associations between role names and view names;
• using the transaction identifier in the log roles structure to access the page context associated with the transaction identifier;
• matching the page name from the accessed page context to a from page name of the process_process_links table;
• and
• using the role name from the log roles table and a view name from the process_process_links table to access a page list that identifies at least one next page.

A method for use with a database management system to determine one or more next users to access a page comprising:

• providing a process_process links table that includes a from page name, a page name, a view name and a link state;
• providing a log roles structure that associates a role name with a transaction identifier associated with a page context;
• providing a plurality of role views that associate userids and subjectids with role names;
• matching a page name and a link state from the page context to a from page name and a link state of a process_process_link table;
• using a view name from the process_process_link table to access one or more role names from the role views table;
• and
• using a subjectid from the page context and the one or more accessed role names to access a userids from one or more role view tables.

A database system comprising:

• means for obtaining page context information that includes userid, subjectid, page name and a transaction identifier;
• means for providing a plurality of role views that associate userids and subjectids with role names;
• means for using the page name from the page context information to access a page definition relation that provides an association between the page name and at least one subject name;
• means for using the at least one subject name from the page definition relation to access a access a role view list that lists one or more of the role views;
• means for using the userid and the subjectid from the page context and at least one role view name from the role view list to access at least one role view that includes a matching userid and a matching subjectid;
• and
• means for producing a log roles structure that associates a role name from the at least one accessed role view and a transaction identifier from the page context.

A database system comprising:

• means for providing a process_process_links table that includes a from page name, a page name and a view name;
• means for providing a log roles structure that associates a role name with a transaction identifier associated with a page context;
• means for providing a role views table that provides associations between role names and view names;
• means for using the transaction identifier in the log roles structure to access the page context associated with the transaction identifier;
• means for matching the page name from the accessed page context to a from page name of the process_process_links table;
• and
• means for using the role name from the log roles table and a view name from the process_process_links table to access a page list that identifies at least one next page.

A database system comprising:

• providing a process_process_links table that includes a from page name, a page name, a view name and a link state;
• means for providing a log roles structure that associates a role name with a transaction identifier associated with a page context;
• means for providing a plurality of role views that associate userids and subjectids with role names;
• means for matching a page name and a link state from the page context to a from page name and a link state of a process_process_link table;
• means for using a view name from the process_process_link table to access one or more role names from the role views table;
• and
• means for using a subjectid from the page context and the one or more accessed role names to access a userids from one or more role view tables.