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

    Join Date
    Aug 2000
    Location
    Denmark
    Posts
    6
    Rep Power
    0
    Does anyone know how column privileges in mysql are set up?
    I have a table called person(firstname,secondname,adress,zip)

    A user called bar should only see the columns firstname and secondname, not adress and zip. If he writes:
    select * from person

    The query should return firstname,secondname.

    I think it has something to do with the table called columns_priv in the database called mysql. Please help me!!!!

    ------------------
    Lasse
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Denmark
    Posts
    6
    Rep Power
    0
    PLEASE HELP ME!!! I am lost!!!

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 06:02 PM
  2. Upgrade from access to mysql
    By karib1 in forum ASP Programming
    Replies: 7
    Last Post: December 16th, 2003, 12:35 PM
  3. Upgrade from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: December 16th, 2003, 12:27 AM
  4. problem: asp files, from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: November 26th, 2003, 03:16 AM

IMN logo majestic logo threadwatch logo seochat tools logo