SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Guru
    Join Date
    Mar 2002
    Posts
    608
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Simple Permissions Question

    Hello,

    I want to confirm that an administrator can offer users specific permissions based on *tables*. Is this possible?

    For instance, let's say there is one database (masterdb) and with 10 users, 10 tables (one per user, such as user1, user2, etc)

    If I want a user to be able to connect to my mysql server from *their domain* (I grant permission to those I trust, obviously) but only be able to use THEIR user/pass to affect ONLY THEIR table, is that possible? Such as:

    GRANT SELECT,INSERT,UPDATE
    ON masterdb.user1
    TO user1@localhost
    IDENTIFIED BY 'password';

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    yes, except that you need quotes like this: 'user1'@'localhost'

  3. #3
    SitePoint Guru
    Join Date
    Mar 2002
    Posts
    608
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Outstanding. And since we'll use the mysql server instead of localhost, I will put that in accordingly.

    Thank you VERY much.


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
  •