報(bào)錯(cuò):permission denied for sequence ... postgresql
1. 原因:postgresql用戶的權(quán)限不足導(dǎo)致
2. 解決方法:
-- 授權(quán)序列給對(duì)應(yīng)用戶即可
GRANT USAGE,SELECT,UPDATE ON ALL SEQUENCES IN SCHEMA public TO some_username;
-- 授權(quán)序列給對(duì)應(yīng)用戶即可
GRANT USAGE,SELECT,UPDATE ON ALL SEQUENCES IN SCHEMA public TO some_username;