Key rotation
A system and method for a mechanism is provided for automatically selecting a new encryption key for re-encrypting data in a target database. New initialization vectors may be specified for re-encrypting each column of data selected for re-encryption. Further, a new initialization vector may be specified for one or more rows of data of a database table in the target database that is selected for re-encryption.
1 . A computer-implemented method for providing security to data in a database, said method comprising:
providing a mechanism for allowing a user to select at least one previously encrypted column; and
providing an automated tool that is associated with said mechanism for allowing said user to specify a new key for re-encryption of data in said at least one selected previously encrypted column.
2 . The computer-implemented method of claim 1 , further comprising allowing said user to specify a new initialization vector for said re-encryption of said at least one selected previously encrypted column.
3 . The computer-implemented method of claim 1 , further comprising allowing said user to request that a new initialization vector for one or more rows be generated for said re-encryption of said at least one selected previously encrypted column.
4 . The computer-implemented method of claim 1 , further comprising allowing said user to specify a batch size for said re-encryption.
5 . The computer-implemented method of claim 1 , further comprising performing said re-encryption.
6 . The computer-implemented method of claim 1 , further comprising logging a history of encryption key usage wit respect to each column selected by said user for said re-encryption.
7 . The computer-implemented method of claim 1 , further comprising providing a management console with a graphical user interface for using said automated tool.
8 . The computer-implemented method of claim 7 , wherein said interface is web-based.
9 . An encryption system for encrypting data in a database, the encryption system comprising:
a means for allowing a user to select at least one previously encrypted column for re-encryption; and
a means for allowing said user to specify a new key for said re-encryption of data in said at least one selected previously encrypted column.
10 . The encryption system of claim 9 , further comprising means for allowing said user to specify a new initialization vector for said re-encryption of said at least one selected previously encrypted column.
11 . The encryption system of claim 9 , further comprising means for allowing said user to specify a new initialization vector for one or more rows for said re-encryption of said at least one selected previously encrypted column.
12 . The encryption system of claim 9 , further comprising means for allowing said user to specify a batch size for said re-encryption.
13 . The encryption system of claim 9 , further comprising means for performing said re-encryption.
14 . The encryption system of claim 9 , further comprising means for logging a history of encryption key usage wit respect to each column selected by said user for said re-encryption.
15 . An apparatus for encrypting data in a database, the apparatus comprising:
one or more processors;
a storage for encryption keys;
an authentication mechanism for authenticating a user who desires to access said database;
a database interface for interfacing with said database;
a management console for allowing said user to manage said data in said database;
a storage medium carrying one or more sequences of one or more instructions which, when executed by said one or more processors, cause said one or more processors to perform the steps of:
providing a mechanism for allowing said user to select at least one previously encrypted column; and
providing an automated tool that is associated with said mechanism for allowing said user to specify a new key for re-encryption of data in said at least one selected previously encrypted column.
16 . The apparatus of claim 15 , further comprising allowing said user to specify a new initialization vector for said re-encryption of said at least one selected previously encrypted column.
17 . The apparatus of claim 15 , further comprising allowing said user to specify a new initialization vector for one or more rows for said re-encryption of said at least one selected previously encrypted column.
18 . The apparatus of claim 15 , further comprising allowing said user to specify a batch size for said re-encryption.
19 . The apparatus of claim 15 , further comprising performing said re-encryption.
20 . The apparatus of claim 15 ,. further comprising logging a history of encryption key usage wit respect to each column selected by said user for said re-encryption.
21 . The apparatus of claim 15 , further comprising providing a management console with a graphical user interface for using said automated tool.
22 . The apparatus of claim 21 , wherein said interface is web-based.
23 . One or more propagated data signals collectively conveying data that causes a computing system to perform a method for providing security to data in a database, said method comprising:
providing a mechanism for allowing a user to select at least one previously encrypted column; and
providing an automated tool that is associated with said mechanism for allowing said user to specify a new key for re-encryption of data in said at least one selected previously encrypted column.
24 . The propagated data signals of claim 23 , further comprising allowing said user to specify a new initialization vector for said re-encryption of said at least one selected previously encrypted column.
25 . The propagated data signals of claim 23 , further comprising allowing said user to specify a new initialization vector for one or more rows for said re-encryption of said at least one selected previously encrypted column.
26 . The propagated data signals of claim 23 , further comprising allowing said user to specify a batch size for said re-encryption.
27 . The propagated data signals of claim 23 , further comprising performing said re-encryption.
28 . The propagated data signals of claim 23 , further comprising logging a history of encryption key usage wit respect to each column selected by said user for said re-encryption.
29 . The propagated data signals of claim 23 , further comprising providing a management console with a graphical user interface for using said automated tool.
30 . The propagated data signals of claim 29 , wherein said interface is web-based.