Michel, It might not be a good idea to have a table named transaction since transact is a reserved word. However, it is working for other users so it should work for the new user. You could try
GRANT ALL PRIVILEGES ON transaction TO max WITH GRANT OPTION. I assume that max is the new user ID. MAX is also a reserved word. John From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Sunday, October 23, 2011 6:05 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Append command not working Hello list, I have added a new user to the database the append command is not working for that user I tried at R> GRANT ALL PRIVILEGES ON transaction TO max GRANT ALL PRIVILEGES ON listeclient TO max SET USER MAX + password APPEND transaction TO listeclient where etat = "P" or etat = "R" -ERROR- Unauthorized access to the table Transaction for user max (2039) I have tried with the other old user's and everything is fine, but if I add a new user append is just not working Any idea Thanks Michel Séguin
