Patent ID: 7562092

Claim:
A computer storage medium storing computer-executable instructions for execution by a processor that creates secured views for a database comprising: creating a database comprising at least one database table and at least one database view, wherein the database table has a row ID, a row business unit, and a row owner; providing a user access to execute the database view while preventing the user from viewing and directly accessing the database table, wherein the user has an associated user ID, an associated user business unit, an associated user business group, and an associated privilege depth and wherein the user ID and the user business unit correspond to an operating system defined user ID and user business unit and a customer relationship management application defined user ID and user business unit; and performing sequential determinations including: 1) determining whether the user is an owner of the row by determining if the value of the row ID is the user ID; and 2) determining whether a business unit of the row is the user business unit by determining if the row business unit is the user business unit and whether the privilege depth is local; and 3) determining whether the business unit of the row is contained in a set of business units associated with the user business unit, where the user business unit is a member of the set of business units and whether the privilege depth is deep; and 4) determining whether the business unit of the row is among a set of business units associated with the user business group in addition to determining whether the privilege depth is global, wherein the privilege depth values of local, deep, and global are separate and distinct values and indicate security access to a user business unit level, an associated user business unit level, and a user business group level, respectively; and 5) determining whether the row ID is associated with the user ID other than determining whether the user is the owner of the row; and configuring the at least one database view to select a row based on the determinations.