Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2003

    Unanswered: Stored Procedures

    Does anyone know if GRANT statements can be issued with a stored procedure in MySQL 5.0a?

    Also, can anyone point me to the correct syntax to INSERT INTO the columns_priv table? I'm not sure how to insert multiple values into the column_priv field. This is what I have tried:

    INSERT INTO columns_priv (host, user, db, table_name, column_name, column_priv) VALUES('%', 'test2', 'pcr', 'pcr_td_data', 'state', 'SELECT' + 'INSERT');


    Last edited by Animaul; 06-14-04 at 10:24.

Posting Permissions

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