Hmmm most likely developers will have a way to get that "pass_str" since they are the Developers.. :)
-----Original Message----- From: Jimmy Guerrero [mailto:[EMAIL PROTECTED] Sent: Thursday, January 10, 2008 3:35 PM To: Sujatha S Cc: Jerome O. Macaranas; mysql@lists.mysql.com Subject: Re: Securing the Data 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. >> >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
