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. > >
