#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    21
    Rep Power
    0
    Hi,

    Is there way to assign passwords to individual users for specific tables in a mysql database? I am not root: I have access to a database via a webhosting service.

    I want to create an e-commerce site using php3 forms that dump into a mysql database. And I want to allow the users, these will be company's wanting data from RFQ's & PO's customers have submitted, I want to grant these users access to particular tables.

    Can I do that?

    Thanks in advance...


    -- Kyoko
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    No. But you can grant access to individual records. Each record is "owned" by a particular user. Just make a field with that users id. You'll need session management.

    Then when you query, make that customer's id part of the query.

Similar Threads

  1. password generation on user auth.
    By nacho_c in forum PHP Development
    Replies: 14
    Last Post: January 16th, 2004, 04:55 AM
  2. Replies: 1
    Last Post: January 7th, 2004, 06:41 PM
  3. want password protect?
    By CaptinKirk in forum Beginner Programming
    Replies: 4
    Last Post: December 18th, 2003, 12:00 PM
  4. password generator- unique?
    By David Graham in forum MySQL Help
    Replies: 1
    Last Post: September 9th, 2001, 05:54 AM
  5. password generator- unique?
    By David Graham in forum PHP Development
    Replies: 1
    Last Post: September 9th, 2001, 05:51 AM

IMN logo majestic logo threadwatch logo seochat tools logo