msquared a écrit :
> Perhaps you want to distribute a CD full of databases, and people buy
> access to specific databases. access = password
IMHO, this method can't protect the content of the CD.
Hace a closer look :
- you have read acces to the CD (files-level read access), but your
MySQL server asks for a password when you want to read a particular
table.
- so, copy the content of the CD to hard-disk (included privs database)
- edit manually (vi -b) the passwords table, replace the existing
encrypted password with one you know the clear text
- use MySQL with the table stored on the hard-disk
- you are prompted for a password, enter yours
- you have access to the CD content without the original password
( you have just win some maps of Australia :)
I think it would work ....
Nicob
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php