Re: filter remote access to tables

[Arjen Lentz]

Arwed Fischer wrote:
> I have a large database with tables and data from different customers.
> The customers need to get remote SELECT ONLY access to the tabels as they want to show the
> content in their website. Is it possible to define that a customer from his remote IP address can
> only SELECT records from a table with his own content identified by a column with ids?

For a user@host combo in the MySQL privilege tables, you can specify specific access rights.
So you can certainly do the above, by setting up the appropriate users in MySQL.

Regards, Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Remote expertise & maintenance for MySQL/MariaDB server environments.

Follow us at http://openquery.com/blog/ & http://twitter.com/openquery