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 SQL

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 granted

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