US 7,979,463 B2 · Database system and method for access control and workflow routing

Abstract

A method for use with a database management system to produce a data structure encoded in computer readable memory that indicates a role associated with a transaction comprising: obtaining page context information that includes userid, subjectid, page name and a transaction identifier; providing a plurality of role views that associate userids and subjectids with role names; 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; 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; 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 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.

Claims8

Dependent claims

A computer-implemented method of identifying a role relationship associated with a user viewing a current page in an interactive application and a candidate set of information that is accessible by the user, the method comprising:

identifying, using a computer processor, a user identification and a subject identification from a page context associated with the current page, wherein the user identification is a database key that identifies the user viewing the current page, and wherein the subject identification is a database key that identifies the candidate set of information that is accessible by the user, the set of information regarding an entity, and wherein a subject name identifies the type of information of the candidate set of information;
identifying, using the computer processor, a page name from the page context, wherein the page name identifies the current page;
determining the role relationship associated with the subject identification and the user identification using a set of role views, which are database views, stored in a database external to the page context, and wherein the role relationship specifies a role played by the user with respect to the entity;
and
storing the role relationship in a log roles table, wherein the log roles table is a database table that is stored external to the page context.

2 more elements

A computer-readable storage medium having computer-executable instructions for identifying a role relationship associated with a user viewing a current page in an interactive application and a candidate set of information that is accessible by the user, comprising instructions for:

identifying a user identification and a subject identification from a page context associated with the current page, wherein the user identification is a database key that identifies the user viewing the current page, and wherein the subject identification is a database key identifies the candidate set of information that is accessible by the user, the set of information regarding an entity, and wherein a subject name identifies the type of information of the candidate set of information;
identifying a page name from the page context, wherein the page name identifies the current page;
using a set of role views, which are database views, stored in a database external to the page context to determine the role relationship associated with the subject identification and the user identification, and wherein the role relationship specifies a role played by the user with respect to the entity;
and
storing the role relationship in a log roles table, wherein the log roles table is a database table that is stored external to the page context.

2 more elements

Dependencies are inferred from the claim text.

Database system and method for access control and workflow routing

Life of this patent

Database system and method for access control and workflow routing

Life of this patent

Abstract

Claims8