Thanks Jimmy.. i have to read it!.. Regards, Suja
On 1/11/08, Jimmy Guerrero <[EMAIL PROTECTED]> wrote: > > Hello, > > http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html > > discusses some available encrypt and decrypt functions native to MySQL. > > -- Jimmy > > Sujatha S wrote: > > Thanks for the update. Is there any method to encrypt the data on mysql? > > > > Regards, > > Suja > > > > On 1/11/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > >> You can limit access to tables in a database using a specific login.. > >> > >> Read on GRANT > >> > >> > >> > >> -----Original Message----- > >> From: Sujatha S [mailto:[EMAIL PROTECTED] > >> Sent: Thursday, January 10, 2008 3:06 PM > >> To: mysql@lists.mysql.com > >> Subject: Securing the Data > >> > >> Hello, > >> > >> > >> Is it possible to encrypt data on mysql database. > >> > >> > >> > >> > >> > >> I have the following requirement. > >> > >> > >> > >> We have a development team, which will be involved in payroll system. > >> > >> > >> > >> They will update the salary information of all the employees in mysql > >> database. Due to this the members in development team have the rights > to > >> access the payroll table, were they can see the salary of others > >> employee > >> and many more information of employee. > >> > >> > >> > >> My question is , do we have any secure method to protect the data. Like > >> storing the data on encrypted format in mysql database. > >> > >> Also, do we have any other possible methods to restrict the development > >> team > >> from access on the data's > >> > >> > >> > >> Regards, > >> > >> Suja > >> > >> > >> > -------------------------------------------------------------------------------------------------------- > >> This message and any files transmitted with it are confidential and > >> intended solely for the use of the individual or entity to whom it is > >> addressed. It may contain sensitive and private proprietary or legally > >> privileged information. No confidentiality or privilege is waived or > >> lost by any mistransmission. If you are not the intended recipient, > >> please immediately delete it and all copies of it from your system, > >> destroy any hard copies of it and notify the sender. You must not, > >> directly or indirectly, use, disclose, distribute, print, or copy any > >> part of this message if you are not the intended recipient. > >> FXDirectDealer, LLC reserves the right to monitor all e-mail > >> communications through its networks. Any views expressed in this > >> message are those of the individual sender, except where the > >> message states otherwise and the sender is authorized to state them. > >> > >> Unless otherwise stated, any pricing information given in this message > >> is indicative only, is subject to change and does not constitute an > >> offer to deal at any price quoted. Any reference to the terms of > >> executed transactions should be treated as preliminary only and subject > >> to our formal confirmation. FXDirectDealer, LLC is not responsible for > any > >> recommendation, solicitation, offer or agreement or any information > >> about any transaction, customer account or account activity contained > in > >> this communication. > >> > >> > > >