phpMyAdmin

Support Requests item #624076, was opened at 2002-10-16 12:53
Message generated for change (Comment added) made by rubo77
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377409&aid=624076&group_id=23067

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Closed
Priority: 1
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Loc Chapeaux (loic1)
Summary: Exclude 1 database from user right

Initial Comment:
How do I exclude one (or more) databases from 
accesing by a certrain MySQL user.

Example;
I have a database with confidential information wich I 
want to hide for all users but the root. Als, I don't want 
anyone but the root, to acces the mysql database.

Is there a special syntax to use in the database right 
field, to exclude one (or more) databases, instead off 
alowing them?

Or do I have to fill in all the names of the databases that 
can be accessed by a certain user? Then what if I 
create a new database. I should change all users' 
database rights? :S

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

Comment By: Ruben Barkow (rubo77)
Date: 2010-03-26 05:41

Message:
so you would have to create a php script, that goes through all names of
the databases and select all mysql-users and then create the right
GRANT-syntax for all users.

so this would be a great feature for pma.
pma can create features, that mysql hasn't

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

Comment By: Loc Chapeaux (loic1)
Date: 2002-10-16 13:24

Message:
Logged In: YES 
user_id=144058

Hi!

Sorry but there is no way to do it: MySQL doesn't know such 
kind of syntax.

Loc

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377409&aid=624076&group_id=23067

[Phpmyadmin-trk-support] [ phpmyadmin-Support Requests-624076 ] Exclude 1 database from user right From: SourceForge.net <noreply@so...> - 2010-03-26 13:27 Support Requests item #624076, was opened at 2002-10-16 08:53 Message generated for change (Comment added) made by lem9 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=377409&aid=624076&group_id=23067 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Closed Priority: 1 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Loc Chapeaux (loic1) Summary: Exclude 1 database from user right Initial Comment: How do I exclude one (or more) databases from accesing by a certrain MySQL user. Example; I have a database with confidential information wich I want to hide for all users but the root. Als, I don't want anyone but the root, to acces the mysql database. Is there a special syntax to use in the database right field, to exclude one (or more) databases, instead off alowing them? Or do I have to fill in all the names of the databases that can be accessed by a certain user? Then what if I create a new database. I should change all users' database rights? :S ---------------------------------------------------------------------- >Comment By: Marc Delisle (lem9) Date: 2010-03-26 09:27 Message: By default, users do not have access to databases. The admin gives them access. If you want to not give access to a db to someone, just don't give it. ---------------------------------------------------------------------- Comment By: Ruben Barkow (rubo77) Date: 2010-03-26 01:41 Message: so you would have to create a php script, that goes through all names of the databases and select all mysql-users and then create the right GRANT-syntax for all users. so this would be a great feature for pma. pma can create features, that mysql hasn't ---------------------------------------------------------------------- Comment By: Loc Chapeaux (loic1) Date: 2002-10-16 09:24 Message: Logged In: YES user_id=144058 Hi! Sorry but there is no way to do it: MySQL doesn't know such kind of syntax. Loc ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=377409&aid=624076&group_id=23067

4 messages have been excluded from this view by a project administrator.