re: Re: Rights required to archive a table

2003-03-07 Thread Victoria Reznichenko
On Friday 07 March 2003 14:08, Ahmed S K Anis wrote: > Yes you can. > > Try this query > grant file on database.* to user@'. It's wrong! You can't specify FILE privilege on the database, only on the global level (*.*). -- For technical support contracts, goto https://order.mysql.com/?r

re: Rights required to archive a table

2003-03-07 Thread Victoria Reznichenko
On Friday 07 March 2003 13:30, Lakshminarayna U wrote: > I want to archive and restore a table in MySQL using SQL > statements. I have tried this by logging in as root user and could > do it fine. But when I created a new user and login as him, I am > not able to archive nor restore. I have grante

Rights required to archive a table

2003-03-07 Thread Lakshminarayna U
Hi, I want to archive and restore a table in MySQL using SQL statements. I have tried this by logging in as root user and could do it fine. But when I created a new user and login as him, I am not able to archive nor restore. I have granted him all the rights. Is there any specific rights need

Re: Rights required to archive a table

2003-03-07 Thread Ahmed S K Anis
Yes you can. Try this query grant file on database.* to user@'. also remember grant file on database.table to user@'. does not work Anis >>> "Lakshminarayna U" <[EMAIL PROTECTED]> Friday, March 07, 2003 5:00:30 PM >>> Hi, I want to archive and restore a table in MySQL using