The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
May. 04, 2010
Filed:
Jul. 30, 2004
Tanmoy Dutta, Sammamish, WA (US);
Girish Chander, Redmond, WA (US);
James R. Hamilton, Bellevue, WA (US);
Alain C. Comeau, Redmond, WA (US);
Tanmoy Dutta, Sammamish, WA (US);
Girish Chander, Redmond, WA (US);
James R. Hamilton, Bellevue, WA (US);
Alain C. Comeau, Redmond, WA (US);
Microsoft Corporation, Redmond, WA (US);
Abstract
The present invention specifies database security at a row level and, optionally, at a column and table level. The systems and methods cluster one or more sets of rows with similar security characteristics and treat them as a named expression, wherein clustered data is accessed based on associated row-level security. The systems and methods specify a syntax that invokes row(s), column(s) and/or table(s) security via programming statements. Such statements include arbitrary Boolean expressions (predicates) defined over, but not restricted to table columns and/or other contextual data. These statements typically are associated with query initiators, incorporated into queries therefrom, and utilized while querying data. Rows of data that return 'true' when evaluated against an aggregate of associated security expressions are said to 'satisfy' the security expressions and enable access to the data stored therein. Such security expressions can be created and invoked via the Structured Query Language (SQL) database programming language.