1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to deny select permission for information_schema to other users in mysql 5.0

Discussion in 'MySQL Forums' started by haraprasad, Jun 18, 2009.

  1. haraprasad

    haraprasad Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    I have created an user by using root user in mysql community server 5.0 on windows Xp, the problem is i don't want show and also access the data from information_schema to the other users in my Database ok, what to do? please reply me asap!
     
  2. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
    By default, users can access information about objects that they have permissions to use anyway. From the MySQL 5.0 Manual: