公开(公告)号：US20060053112A1

公开(公告)日：2006-03-09

申请号：US10711929

申请日：2004-10-13

申请人： Rajnish Chitkara ,  Barbara Banks ,  Anita Patel

发明人： Rajnish Chitkara ,  Barbara Banks ,  Anita Patel

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  G06F21/6227 ,  H04L9/0894 ,  Y10S707/99931 ,  Y10S707/99939 ,  Y10S707/99948

摘要： A database system providing SQL extensions for automated encryption and decryption of column data is described. In one embodiment, for example, in a database system, a method is described for providing automated encryption support for column data, the method comprises steps of: defining Structured Query Language (SQL) extensions for creating and managing column encryption keys, and for creating and managing database tables with encrypted column data; receiving an SQL statement specifying creation of a particular column encryption key; receiving an SQL statement specifying creation of a database table having particular column data encrypted with the particular column encryption key; and in response to a subsequent database operation that requires the particular column data that has been encrypted, automatically decrypting the particular column data for use by the database operation.

摘要翻译： 描述了提供用于列数据的自动加密和解密的SQL扩展的数据库系统。 在一个实施例中，例如，在数据库系统中，描述了一种为列数据提供自动加密支持的方法，该方法包括以下步骤：定义用于创建和管理列加密密钥的结构化查询语言（SQL）扩展，以及用于创建 并使用加密的列数据管理数据库表; 接收指定创建特定列加密密钥的SQL语句; 接收指定创建具有用特定列加密密钥加密的特定列数据的数据库表的SQL语句; 并且响应于需要加密的特定列数据的后续数据库操作，自动解密特定列数据以供数据库操作使用。

公开(公告)号：US20140188938A1

公开(公告)日：2014-07-03

申请号：US13729698

申请日：2012-12-28

申请人： Barbara Banks ,  Rajnish Chitkara

发明人： Barbara Banks ,  Rajnish Chitkara

IPC分类号： G06F17/30

CPC分类号： G06F21/6227 ,  G06F17/30286 ,  G06F2221/2117 ,  G06F2221/2141

摘要： Methods, systems and computer-readable storage mediums encoded with computer programs executed by one or more processors for conditional role activation in a database are disclosed. In an embodiment, a request to activate a role for a user of a database system is received, and a predicate for conditional activation of the role is determined. The conditions of the predicate are evaluated, and if the conditions of the predicate are satisfied, the role is activated for the user. If, however, one or more of the conditions of the predicate are not satisfied, the role is not activated for the user.

摘要翻译： 公开了用一个或多个处理器执行的用于数据库中的条件角色激活的计算机程序编码的方法，系统和计算机可读存储介质。 在一个实施例中，接收到为数据库系统的用户激活角色的请求，并且确定角色的条件激活的谓词。 评估谓词的条件，如果满足谓词的条件，则为用户激活角色。 但是，如果谓词的一个或多个条件不满足，则该用户不会激活该角色。

公开(公告)号：US09330276B2

公开(公告)日：2016-05-03

申请号：US13729698

申请日：2012-12-28

申请人： Barbara Banks ,  Rajnish Chitkara

发明人： Barbara Banks ,  Rajnish Chitkara

IPC分类号： G06F17/30 ,  G06F21/62

CPC分类号： G06F21/6227 ,  G06F17/30286 ,  G06F2221/2117 ,  G06F2221/2141

摘要： Methods, systems and computer-readable storage mediums encoded with computer programs executed by one or more processors for conditional role activation in a database are disclosed. In an embodiment, a request to activate a role for a user of a database system is received, and a predicate for conditional activation of the role is determined. The conditions of the predicate are evaluated, and if the conditions of the predicate are satisfied, the role is activated for the user. If, however, one or more of the conditions of the predicate are not satisfied, the role is not activated for the user.

摘要翻译： 公开了用一个或多个处理器执行的用于数据库中的条件角色激活的计算机程序编码的方法，系统和计算机可读存储介质。 在一个实施例中，接收到为数据库系统的用户激活角色的请求，并且确定角色的条件激活的谓词。 评估谓词的条件，如果满足谓词的条件，则为用户激活角色。 但是，如果谓词的一个或多个条件不满足，则该用户不会激活该角色。

公开(公告)号：US20080033960A1

公开(公告)日：2008-02-07

申请号：US11840306

申请日：2007-08-17

申请人： Barbara Banks ,  Rajnish Chitkara ,  Shiping Chen

发明人： Barbara Banks ,  Rajnish Chitkara ,  Shiping Chen

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30389 ,  G06F21/6227 ,  H04L9/0894 ,  Y10S707/99932 ,  Y10S707/99939 ,  Y10S707/99948

摘要： A database system providing encrypted column data support with decrypt default functionality. In a database system, a method providing automated encryption support for column data comprises steps of: defining Structured Query Language (SQL) extensions for creating and managing column encryption keys and database tables with encrypted column data; receiving an SQL statement specifying creation of a column encryption key; receiving an SQL statement specifying creation of a database table having particular column data encrypted with the column encryption key; receiving an SQL statement specifying a default value to be provided in response to requests for the column data without decrypt permission; in response to a subsequent database operation requesting encrypted column data from a user with decrypt permission, automatically decrypting the column data; and in response to a subsequent database operation requesting the encrypted column data from a user without decrypt permission, returning the default value.

摘要翻译： 数据库系统提供加密列数据支持与解密默认功能。 在数据库系统中，为列数据提供自动加密支持的方法包括以下步骤：定义用于创建和管理具有加密列数据的列加密密钥和数据库表的结构化查询语言（SQL）扩展; 接收指定创建列加密密钥的SQL语句; 指定创建具有用列加密密钥加密的特定列数据的数据库表的SQL语句; 接收一条SQL语句，指定响应于没有解密权限的列数据的请求而提供的默认值; 响应于从具有解密权限的用户请求加密列数据的后续数据库操作，自动解密列数据; 并且响应于后续的数据库操作在没有解密权限的情况下从用户请求加密的列数据，返回默认值。