Re: Password on DB Files not on DB server

2007-02-11 Thread mos

At 12:11 AM 2/11/2007, you wrote:

This is true, if the db is still on same db server.

Correct me if I am wrong, but it will not protect if some body copies the
files to other DB server, then they can see the DB

Suhas


Suhas,
You are correct. If the person has physical access to the MySQL 
table, then there is nothing you can do to protect it unless you want to 
encrypt individual columns using functions like AES_Encrypt() . But then 
you lose the ability to use "<" or ">" on those column indexes. See 
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html for more info.


Mike 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Password on DB Files not on DB server

2007-02-10 Thread Suhas Pharkute

This is true, if the db is still on same db server.

Correct me if I am wrong, but it will not protect if some body copies the
files to other DB server, then they can see the DB

Suhas


Re: Password on DB Files not on DB server

2007-02-10 Thread Suhas Pharkute

This is true, if the db is still on same db server.

Correct me if I am wrong, but it will not protect if some body copies the
files to other DB server, then they can see the DB

Suhas

On 2/10/07, mos <[EMAIL PROTECTED]> wrote:


At 10:49 PM 2/10/2007, Suhas Pharkute wrote:
>Hi,
>
>I am sure this is been asked many times before, but seems like I could
not
>find answer to it so here you go,
>
>Is there any way to put password on Data base(files) itself rather than
DB
>server?

See the Grant command to set up users where you can allow them access to
certain tables.
http://dev.mysql.com/doc/refman/5.1/en/grant.html


>If yes how to achive it? If no, any suggestions which db support that?

Here is an article that may help.
http://www.securityfocus.com/infocus/1667

Mike

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Password on DB Files not on DB server

2007-02-10 Thread Suhas Pharkute

This is true, if the db is still on same db server.

Correct me if I am wrong, but it will not protect if some body copies the
files to other DB server, then they can see the DB

Suhas

On 2/10/07, mos <[EMAIL PROTECTED]> wrote:


At 10:49 PM 2/10/2007, Suhas Pharkute wrote:
>Hi,
>
>I am sure this is been asked many times before, but seems like I could
not
>find answer to it so here you go,
>
>Is there any way to put password on Data base(files) itself rather than
DB
>server?

See the Grant command to set up users where you can allow them access to
certain tables.
http://dev.mysql.com/doc/refman/5.1/en/grant.html


>If yes how to achive it? If no, any suggestions which db support that?

Here is an article that may help.
http://www.securityfocus.com/infocus/1667

Mike

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]




Re: Password on DB Files not on DB server

2007-02-10 Thread mos

At 10:49 PM 2/10/2007, Suhas Pharkute wrote:

Hi,

I am sure this is been asked many times before, but seems like I could not
find answer to it so here you go,

Is there any way to put password on Data base(files) itself rather than DB
server?


See the Grant command to set up users where you can allow them access to 
certain tables.

http://dev.mysql.com/doc/refman/5.1/en/grant.html



If yes how to achive it? If no, any suggestions which db support that?


Here is an article that may help.
http://www.securityfocus.com/infocus/1667

Mike 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Password on DB Files not on DB server

2007-02-10 Thread Suhas Pharkute

Hi,

I am sure this is been asked many times before, but seems like I could not
find answer to it so here you go,

Is there any way to put password on Data base(files) itself rather than DB
server?

If yes how to achive it? If no, any suggestions which db support that?

Thank you in advance!

Suhas