Re: privileges and deleting from tables

2007-06-06 Thread Baron Schwartz
sr_id`) ON DELETE CASCADE". By the way I forgot to mention that engine is of course InnoDB. Baron Schwartz wrote: Hi Sergei, Sergei wrote: Hello, I have a weird problem with privileges and deleting from tables. I have a MySQL user that has only "mydb2" database specific privil

Re: privileges and deleting from tables

2007-06-06 Thread Sergei
ELETE CASCADE". By the way I forgot to mention that engine is of course InnoDB. Baron Schwartz wrote: Hi Sergei, Sergei wrote: Hello, I have a weird problem with privileges and deleting from tables. I have a MySQL user that has only "mydb2" database specific privileges (no SU

Re: privileges and deleting from tables

2007-06-06 Thread Baron Schwartz
Hi Sergei, Sergei wrote: Hello, I have a weird problem with privileges and deleting from tables. I have a MySQL user that has only "mydb2" database specific privileges (no SUPER privileges). All tables were created prior to granting any privileges. Privileges have been grant

privileges and deleting from tables

2007-06-06 Thread Sergei
Hello, I have a weird problem with privileges and deleting from tables. I have a MySQL user that has only "mydb2" database specific privileges (no SUPER privileges). All tables were created prior to granting any privileges. Privileges have been granted by this query: "GRANT