rivas0x Posted January 8, 2018 Posted January 8, 2018 My error is: "permission denied for sequence usuarios_id_seq"
Bailey Posted January 8, 2018 Posted January 8, 2018 Are you using MySQL? And could you please provide more information on the issue you are receiving please.
rivas0x Posted January 8, 2018 Author 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
wolstech Posted January 8, 2018 Posted January 8, 2018 That's odd...Krydos might know why this is happening. Escalating.
Krydos Posted January 9, 2018 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?
rivas0x Posted January 9, 2018 Author 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...
Krydos Posted January 9, 2018 Posted January 9, 2018 Did you grant the postgresql user rivas0x_root access to the database rivas0x_TSJ?
rivas0x Posted January 9, 2018 Author 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.
Recommended Posts