#Ems sql manager for mysql how tyo delete database update
| created | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | | security_type | enum('INVOKER','DEFINER') | NO | | DEFINER | | | is_deterministic | enum('YES','NO') | NO | | NO | | | sql_data_access | enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') | NO | | CONTAINS_SQL | | | language | enum('SQL') | NO | | SQL | | | type | enum('FUNCTION','PROCEDURE') | NO | PRI | NULL | | | Field | Type | Null | Key | Default | Extra | Here is the description of mysql.proc: +-+-+-+-+-+-+ When someone has the clearance to call a stored procedure, the grants for the user who called the stored procedure must be checked. So my question, What is the Compile button trying to do? Why does it want to select er? I think that editing a stored procedure is two steps of drop and re create it, why does it want to do more? Operation : SHOW CREATE PROCEDURE `reportingdb`.`100_rpt_campaign_ip` P.`type` = 'PROCEDURE' and p.`db`='reportingdb' and P.`modified`, p.`sql_mode`, p.`comment` from `mysql`.`proc` as p where
P.`language`, p.`sql_data_access`, p.`is_deterministic`, p.`security_type`, Operation : select p.`db`, p.`name`, p.`type`, p.`specific_name`, Result : "SELECT command denied to user for table
Operation : SELECT * FROM er ORDER BY User, Host
Operation : show variables like 'character_set_results' This is the action EMS SQL Manager take when click the Compile button. I can create, drop procedure in mysql command line client without problem.Īfter some investigation, I still do not understand EMS SQL Manager. GRANT SELECT ON `mysql`.`user` TO SELECT ON `mysql`.`db` TO SELECT ON `mysql`.`tables_priv` TO SELECT ON `mysql`.`columns_priv` TO SELECT ON `mysql`.`procs_priv` TO my question is, WHY EMS SQL Manager need those privileges? I find out that EMS SQL Manager ask for select privilege in some tables, so I need to grant this user some extra permissions. One of my developers need to edit store procedure, so I grant him: GRANT CREATE ROUTINE, ALTER ROUTINE ON `testdb`.* TO he clicked edit store in EMS SQL Manager, what he got is: SELECT command denied to user for table 'user' I have a strange problem with EMS SQL Manager.
0 kommentar(er)
