Patent ID: 9330276
Filing Date: 2016-05-03
CPC Classification: G06F

Claim Text:
1. A computer-implemented method, comprising: receiving, by a database that enforces which users may activate which roles for the database, a request to activate a role for a first user of the database, the role corresponding to one or more privileges associated with functions of the database; determining, by the database, that a predicate for conditional activation of the role using a ROLE element of SQL (structured query language) was defined and stored in the database prior to receiving the request, wherein a first predicate includes one or more conditions that must be satisfied for the role to be activated for the first user, and wherein a second predicate includes one or more conditions different from the first predicate that must be satisfied for the role to be activated for a second user of the two or more users; evaluating the conditions of the first predicate by the database, wherein the database determines whether the conditions of the first predicate are satisfied; if the conditions of the first predicate are satisfied, activating, by the database, the role for the user, wherein the activating enables the first user to perform the functions of the database associated with the role; and if one or more of the conditions of the first predicate are not satisfied, not activating, by the database, the role for the first user, wherein the not activating prevents the first user from performing the functions of the database associated with the role.