rivas0x Posted January 8, 2018 Share Posted January 8, 2018 My error is: "permission denied for sequence usuarios_id_seq" Link to comment Share on other sites More sharing options...
Luigi123 Posted January 8, 2018 Share Posted January 8, 2018 Moved to Customer Service. Link to comment Share on other sites More sharing options...
Bailey Posted January 8, 2018 Share Posted January 8, 2018 Are you using MySQL? And could you please provide more information on the issue you are receiving please. Link to comment Share on other sites More sharing options...
rivas0x Posted January 8, 2018 Author Share Posted January 8, 2018 (edited) Are you using MySQL? And could you please provide more information on the issue you are receiving please.No, I'm using postgre. When I make any insert to the db is imposible cause this message come out. Edited January 8, 2018 by rivas0x Link to comment Share on other sites More sharing options...
wolstech Posted January 8, 2018 Share Posted January 8, 2018 That's odd...Krydos might know why this is happening. Escalating. Link to comment Share on other sites More sharing options...
Krydos Posted January 9, 2018 Share Posted January 9, 2018 Insert is working for me on postgresql on Johnny. Which database are you trying to insert into? Which username are you running the insert command from? Are you using command line or pgphpadmin or something else? Link to comment Share on other sites More sharing options...
rivas0x Posted January 9, 2018 Author Share Posted January 9, 2018 Insert is working for me on postgresql on Johnny. Which database are you trying to insert into? Which username are you running the insert command from? Are you using command line or pgphpadmin or something else?The database name is: rivas0x_TSJ, the user is: rivas0x_root and I can't insert using command line in my proyect, but in the phppgadmin I use the same insert instruction and it work fine... Link to comment Share on other sites More sharing options...
Krydos Posted January 9, 2018 Share Posted January 9, 2018 Did you grant the postgresql user rivas0x_root access to the database rivas0x_TSJ? Link to comment Share on other sites More sharing options...
rivas0x Posted January 9, 2018 Author Share Posted January 9, 2018 You mean this: https://prnt.sc/hxwhqp ? Link to comment Share on other sites More sharing options...
rivas0x Posted January 9, 2018 Author Share Posted January 9, 2018 I used:" GRANT USAGE ON SEQUENCE public. usuario_id_seq TO public;" and this way I could insert, in case someone requires the solution, thank you. Link to comment Share on other sites More sharing options...
Recommended Posts