SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Guru phantom007's Avatar
    Join Date
    May 2008
    Posts
    737
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Question MySQL - Table Level Permissions

    Hi

    I have a MySQL 5.x database. I have 5 tables in it. Is there anyway I can have 5 users assigned to 5 different tables in such a way that one user can have access to the DB but can ONLY view his own table and not view any other tables in that DB?


    Pls suggest.


    Thanks

  2. #2
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,580
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Yes, see the manual, scroll to "Table Privileges"

    http://dev.mysql.com/doc/refman/5.1/en/grant.html

    Don't grant access to the database, only to the table


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •