Re: what permissions do i need to set

2002-06-26 Thread Egor Egorov 

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

Re: what permissions do i need to set

2002-06-26 Thread Alexander Barkov 

Shon Stephens wrote:
 
 i have an application that will allow me to rotate mysql table using
 date variable substition. in other words
 
 table=tblname.%m%d%Y
 
 if i am using a remote system to host the application, what

Host doesn't matter. localhost and remote hosts are processed
in the same manner.

 permissions to i need to give the remote application user so that it
 can properly select,update,insert records into existing tables, and
 create new tables as it needs to? 

grant create,select,insert,update on db.* to 'user'@'host'

-- 
For technical support contracts, visit https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED]
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
/_/  /_/\_, /___/\___\_\___/   Izhevsk, Russia
___/   www.mysql.com   +7-902-856-80-21


-
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

what permissions do i need to set

2002-06-25 Thread Shon Stephens 

 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

i have an application that will allow me to rotate mysql table using
date variable substition. in other words

table=tblname.%m%d%Y

if i am using a remote system to host the application, what
permissions to i need to give the remote application user so that it
can properly select,update,insert records into existing tables, and
create new tables as it needs to? 

thanks,
shon

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com

iQA/AwUBPRivpBerBYVUKJeKEQLNsgCg19LSGf9BrgqodVjACoeAZJVo3gIAoN/v
z6I9zjzmbCZWpKZlGiJ0yQU2
=Gxyx
-END PGP SIGNATURE-

-
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