Feature Request: "read-only" Mode

[vygi]

Hello here,

my boss was scared when he saw that every dork may drop tables and databases with just two mouse clicks.

I know, this is a access right / privilege related question… but anyhow:

it may be useful to have a “read only” mode (maybe even protected by some password) with all potentially dangerous buttons and menu entries switched off because these knobs with red crosses are quite attractive 😉

Thanks for reading,

Vygi

[peterlaursen]

The MySQL user management has all you need! For instance create a user with SELECT, INSERT and UPDATE privilege to a specific database and use that user for connection.

You should not give user credentials for a user that has DROP-privilege to “every dork” 😀

Your problem is database management. It is YOUR problem. Not af problem of webyog!

[vygi]

peterlaursen wrote on Oct 1 2005, 02:28 AM:

You should not give user credentials for a user that has DROP-privilege to “every dork”  😀

Your problem is database management.  It is YOUR problem.  Not af problem of webyog!

[post=”7383″]<{POST_SNAPBACK}>[/post]

Yes, I know I know I know, this is not a problem of webyog nor any other software applicaton;

our current problem is: some “dork” (not me) has created just one single MySQL DB user with all possible privileges, and this account is being used in all possible shell/perl/php sripts and crontab jobs (user name & password everywhere hard-coded) and also in ODBC data sources in almost every workstation, so the alternatives are to create a proper read-only user and either change all scripts (barely possible in a running system) or change all data sources (easily possible but lots of manual work) or – just as work-around as long as real solution – use “safe” clients without these attractive “drop” and “delete” knobs. This is what we do.

Sorry for disturbing…

Vygi

[Author]

Posts