Re: New user with error 1461
Posted by: Don Lewis
Date: February 26, 2014 09:23AM

He is trying a regular statement:
SELECT * FROM order_mgmt.okiitio;
1461 can not generate more than max_prepared_stmt_count statements (current value: 16382)

but specific column, works:
select APPL_ID, DC_NO , DIV_NO, ITM_NO, SKU_CD, OWN_CD from okiitio ;
no error.

Problem user:
GRANT ALL PRIVILEGES ON `order_mgmt`.* TO 'gceitha'@'%'
other users can do queries with no error.
Setup of the other users identical.
Other user:
GRANT ALL PRIVILEGES ON `order_mgmt`.* TO 'DiCicco'@'%'

Options: ReplyQuote


Subject
Written By
Posted
February 19, 2014 08:49AM
February 19, 2014 08:50AM
February 24, 2014 04:37PM
Re: New user with error 1461
February 26, 2014 09:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.