How to prevent export to a user

[Sanjay katiyar]

Hi All,

I have phpMyAdmin-3.x on Fedora 8.
I have created one user in the mysq and given 'select, create, insert, update, delete' privileges.
Now when I login to PhpMyAdmin as this User I DO NOT want to give Export .
Is this possible?

Thanks.

Sanjay Katiyar
Social career building platform
http://www.codemunch.com

---

Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8.
------------------------------------------------------------------------------

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

[Michal Čihař]

Hi

Dne Wed, 1 Jul 2009 12:48:14 +0530 (IST)
Sanjay katiyar <sanjay_katiyar1@...> napsal(a):

> I have phpMyAdmin-3.x on Fedora 8.
> I have created one user in the mysq and given 'select, create, insert, update, delete' privileges.
> Now when I login to PhpMyAdmin as this User I DO NOT want to give Export .
> Is this possible?

No, there are no limitations in phpMyAdmin, it just allows you what you
can do with MySQL - when user can do SHOW CREATE TABLE, he can get
table structure, and when he can SELECT, he can get the table data. No
matter whether he displays it or exports.

--
        Michal Čihař | http://cihar.com | http://phpmyadmin.cz


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

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

[Sanjay katiyar]

Thanks Michal,


Sanjay Katiyar
Social career building platform
http://www.codemunch.com

--- On Wed, 1/7/09, Michal Čihař <michal@...> wrote:

From: Michal Čihař <michal@...>
Subject: Re: [Phpmyadmin-users] How to prevent export to a user
To: phpmyadmin-users@...
Date: Wednesday, 1 July, 2009, 1:54 PM

Hi

Dne Wed, 1 Jul 2009 12:48:14 +0530 (IST)
Sanjay katiyar <sanjay_katiyar1@...> napsal(a):

> I have phpMyAdmin-3.x on Fedora 8.
> I have created one user in the mysq and given 'select, create, insert, update, delete' privileges.
> Now when I login to PhpMyAdmin as this User I DO NOT want to give Export .
> Is this possible?

No, there are no limitations in phpMyAdmin, it just allows you what you
can do with MySQL - when user can do SHOW CREATE TABLE, he can get
table structure, and when he can SELECT, he can get the table data. No
matter whether he displays it or exports.

--
    Michal Čihař | http://cihar.com | http://phpmyadmin.cz

-----Inline Attachment Follows-----

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

-----Inline Attachment Follows-----

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

---

Love Cricket? Check out live scores, photos, video highlights and more. Click here.
------------------------------------------------------------------------------

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

[Marc Delisle-2]

Sanjay katiyar a écrit :
> Hi All,
>
> I have phpMyAdmin-3.x on Fedora 8.
> I have created one user in the mysq and given 'select, create, insert,
> update, delete' privileges.
> Now when I login to PhpMyAdmin as this User I DO NOT want to give Export .
> Is this possible?
>
> Thanks.

Well, strictly speaking you can do this, provided you modify your own
copy of phpMyAdmin to verify whether this user is logged in and change
the menu accordingly.


--
Marc Delisle
http://infomarc.info

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

[cand. inf. Alexander M. Turek]

Hi list,

Marc Delisle schrieb:
>
> Well, strictly speaking you can do this, provided you modify your own
> copy of phpMyAdmin to verify whether this user is logged in and change
> the menu accordingly.

Well, the HTML phpMyAdmin produces is sort of an export as well. If the
reason behind hiding the export function is security, it won't work. As
long as the user is allowed to perform SELECT, he will get the data and
as long as he's able to get the data he can convert it to any format he
wants. It just gets a bit more tricky if you hide the export function. :-)

Regards,

Alexander



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

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