search

Shooter7119 / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

Grant privileges #1675

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. open users
2. select the user
3. click on tab  "privileges scheme"
4. select the scheme
5. add privileges available
6. apply

when I return, all changes in window are discarted.
but in terminial all the privileges are ok

/* 20:58:58*/ SELECT user FROM mysql.user LIMIT 1;
/* 20:58:58*/ SELECT * FROM mysql.user ORDER BY user;
/* 20:58:58*/ SELECT * FROM mysql.db;
/* 20:58:59*/ SHOW PRIVILEGES;
/* 21:00:50*/ SELECT USER, HOST FROM mysql.db WHERE USER = 'loja_ataliba' AND 
HOST = '%' AND DB = 'loja\_stiff';
/* 21:00:50*/ GRANT SELECT, DELETE, UPDATE ON `loja\_stiff`.* TO 
'loja_ataliba'@'%';
/* 21:00:50*/ REVOKE CREATE ROUTINE, CREATE VIEW, ALTER, SHOW VIEW, CREATE, 
ALTER ROUTINE, EVENT, INSERT, TRIGGER, GRANT OPTION, REFERENCES, DROP, EXECUTE, 
LOCK TABLES, CREATE TEMPORARY TABLES, INDEX ON `loja\_stiff`.* FROM 
'loja_ataliba'@'%';
/* 21:00:50*/ FLUSH PRIVILEGES;

Original issue reported on code.google.com by br...@stiff.com.br on 22 Mar 2013 at 12:05

GoogleCodeExporter commented 9 years ago

Original comment by stuart02 on 25 Oct 2013 at 2:01