Luc,
I think you have to do the manual inserts to make this work before the
tables are there. I wrestled with this problem briefly, before writing a
quick script.
Scott Helms
Director of Technology, ZCorum
----- Original Message -----
From: "Luc Foisy" <[EMAIL PROTECTED]>
To: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]>
Sent: Friday, March 15, 2002 10:44 AM
Subject: Grants to a database table that doesn't exist yet
>
> Is there someway I can force a Grant to take if the database table doesn't
> exist yet?
>
> I have the database created, awaiting the data that is being dropped into
> it, but I want to set up privileges to it before it exists so its ready to
> go live in an instant
>
> mysql> GRANT DELETE,SELECT,UPDATE on qbslive.PRINTJOB to
> PrintHandler@'192.168.0.250' identified by 'passwd';
> ERROR 1146: Table 'qbslive.PRINTJOB' doesn't exist
>
> there would be several grant statements ( about 20, trying to keep the
> database controlled as much as possible)
>
> I suppose I could do this by editing the tables directly, there is just a
> bit more work involved ( user and tables_priv inserts ). I would really
like
> the server to do the work though through the grant though
>
> I could create the table first, then make the grants, then delete the
> tables, BUT I have a slave replicating this database ( so when I load the
> data, it will be replicated right from the get go) and I would rather not
> have that unneccissary stuff in the bin logs. ( now I see I should have
> started the replication after I did all the messing around )
>
> I don't want to stop anything and reconfigure it, cause I know its working
> now and I don't want to make something not work :)
>
> Anyways, can I force a GRANT on a table that doesnt exist?
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
