Patent ID: 7676470

Claim:
A method for providing security to a data warehousing application, comprising: identifying a dimension(s) defined for a set of end-user view definitions for viewing data in a data warehouse, wherein the step of identifying dimensions is automatically performed on a periodic basis or on demand; examining each dimension for an associated security table, wherein the examining identifies each dimension without an associated security table; generating security tables for identified dimensions without an associated security table; scanning security tables to analyze inputs within the security tables, wherein the step of analyzing inputs is performed on a periodic basis or on demand; converting the inputs to at least one of constraint(s) or filter(s) within the end-user view definition, wherein a constraint requires a user(s) to have an explicit access permission, and wherein a filter grants the user(s) implicit access; and updating the end-user view definitions for the data warehouse, wherein the updating is based on the analyzing inputs within the security tables.