 UBBFriend: Email This Page to Someone! |
 DevShed Discussion Forums
 MySQL
 User with no rights can see all of my databases!
|
| next newest topic | next oldest topic |
| Author | Topic: User with no rights can see all of my databases! |
|
JGLyons Junior Member |
posted November 24, 1999 02:56 PM
   
I'm going crazy!! I'm trying to set up a user on our MySQL server who can access a single database and edit it etc. I've got the database ser up on localhost and a user. I've got all of the user rights set to N and I've just set up Y in the first 6 collumns of the database table for the database. The problem is that when I use MySQL admin the display is showing databsases that are admin access only. I'm sure that all of the user rights are restricted to N so why can the lowest of the low user with almost no access rights see all of the databases on localhost. Should I be setting up another host name? Any guesses, or even knowledgable answers. Ta John |
|
rod k Member |
posted November 29, 1999 06:57 AM
Being able to see the names of databases on the server is not the same as being able to access them. I agree that it could be better. |
|
JGLyons Junior Member |
posted November 29, 1999 12:34 PM
Is that correct then that any user on our server with access rights to only one database can still see the names of the other datbases even though they can't access any of them and can't see any tables. |
|
rod k Member |
posted November 29, 1999 12:37 PM
Yes, that's correct. There may be a way around that, but I haven't heard of one. |
All times are MST (US) | next newest topic | next oldest topic |
  |
|
Contact Us | DevShed.com
Copyright © 1997-2000 ngenuity. All rights reserved.
Powered by: Ultimate Bulletin Board, Version 5.41a
© Infopop Corporation (formerly Madrona Park, Inc.), 1998 - 1999.