how to deny users to login to other databases on the same mysql server

[Richard Jones-30]

Some parts of this message have been removed. Learn more about Nabble's security policy.

We have a lot of mysql databases, I created a user to be able to use only one one table, however, when he logs into phpmyadmin, he can see ALL the different tables, select them and everything.
So how can I make it where he can only see data from that ONE table, and not all the others?

I thought that if I granted him permissions on those databases with NOTHING in them he would not be able to view the data, but when I login as him, he still can see everything. I'm afraid he may accidentally dump everything, and this could kill our business.

So can anyone please let me know how I can find out how to do this?
Thank you much,
Richard

------------------------------------------------------------------------------

_______________________________________________
Phpmyadmin-users mailing list
Phpmyadmin-users@...
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users

[Marc Delisle-2]

Richard Jones a écrit :

> We have a lot of mysql databases, I created a user to be able to use
> only one one table, however, when he logs into phpmyadmin, he can see
> ALL the different tables, select them and everything.
> So how can I make it where he can only see data from that ONE table, and
> not all the others?
>
> I thought that if I granted him permissions on those databases with
> NOTHING in them he would not be able to view the data, but when I login
> as him, he still can see everything. I'm afraid he may accidentally dump
> everything, and this could kill our business.
>
> So can anyone please let me know how I can find out how to do this?
> Thank you much,
> Richard

This user probably has a global SELECT privilege (or other global
privileges) so remove this privilege from him.

--
Marc Delisle
http://infomarc.info

------------------------------------------------------------------------------
_______________________________________________
Phpmyadmin-users mailing list
Phpmyadmin-users@...
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users