Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Sqlyog and database permissions

forums › forums › SQLyog › Using SQLyog › Sqlyog and database permissions

  • This topic is empty.
Viewing 6 reply threads
  • Author
    Posts
    • May 15, 2003 at 8:43 am #7938
      alistair
      Member

      Does anyone know how to set up access permissions on MySql to restrict users to only seeing their own databases? I have lots of users with different databases on the server and I don't want them seeing each others' databases. This can be done with PHPMyAdmin, which we use just now but I'd like to get them to use sqlyog as it's more friendly! Problem is, if they log in using their username/password, they see ALL databases. They only see their own database if they use PHPMyAdmin. As you can imagine, this is a security nightmare as some users store usernames/passwords for websites in plain text in their databases!

      If this can't be done then can the functionality be added in a future release?

      Cheers,

      Alistair

    • May 15, 2003 at 8:52 am #14285
      alistair
      Member

      OK, I'm stupid! PHPMyAdmin HIDES all the databases apart from your own. sqlyog doesn't! You can see ALL the databases on the server but you can only access your own. It's still a security hole though. Can it be set up to ignore/hide all databases that you don't have rights on?

      Alistair

    • May 15, 2003 at 10:49 am #14286
      Shadow
      Member

      I use SQLyog v3.11 and it does not display all the databases, just the ones the user has access to. Try checking the global rights!

    • May 15, 2003 at 11:24 am #14287
      alistair
      Member

      I downloaded 3.11 and it still displays all the databases! When you say Global rights – do you mean on the mysql server or is it a setting in sqlyog?

      Thanks for your help,

      Alistair

    • May 15, 2003 at 12:44 pm #14288
      CalEvans
      Member

      This is an issue with MySQL. myPHPAdmin works around it but traditionally, clients have not had to work around it as the servers have dealt properly with it.

      I'm hoping that this will be resolved in the 4.x brance of MySQL but it's really not the client's (SQLyog) issue to resolve.

      =C=

    • May 15, 2003 at 12:59 pm #14289
      alistair
      Member

      OK, thanks for that Cal 🙂

    • May 15, 2003 at 3:49 pm #14290
      Shadow
      Member

      It seems, it is already done in MySql 4.1, because I don't get all the databases listed and I use 4.1-alpha…

  • Author
    Posts
Viewing 6 reply threads
  • You must be logged in to reply to this topic.