Shon,
Tuesday, June 25, 2002, 8:54:39 PM, you wrote:
SS> i have an application that will allow me to rotate mysql table using
SS> date variable substition. in other words
SS> table=tblname.%m%d%Y
SS> if i am using a remote system to host the application, what
SS> permissions to i need to give the remote application user so that it
SS> can properly select,update,insert records into existing tables, and
SS> create new tables as it needs to?
What about setting up SELECT, UPDATE, INSERT privileges (may be DELETe for
cleaning table?) on your existing table and CREATE privileges on your
database. Take a look at GRANT statement:
http://www.mysql.com/doc/G/R/GRANT.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
