SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Addict
    Join Date
    Jan 2004
    Location
    Nashville
    Posts
    335
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Contract Programmer Access to DB/Tables

    Is there a tool out there that allows me to grant access to only certain databases and tables?

    The server uses Plesk. I need to be able to grant limited access to database and table to freelance/contract programmers.

    Right now in phpMyAdmin it appears to be all or nothing?

    Thank you.

  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)
    mysql supports this, but plesk might not expose that level of granularity. i've never used plesk.
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast

  3. #3
    SitePoint Guru
    Join Date
    Dec 2005
    Posts
    982
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Plesk does not allow you to create users without full privileges. You create users per database, and those users can have full rights to every table in that database.

    My host created us an additional installation of phpMyAdmin that would allow us to create users with proper privileges.
    MySQL v5.1.58
    PHP v5.3.6


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
  •