How do ordinary users grant create sequence

From: "jiangcj(at)winhong(dot)com" <jiangcj(at)winhong(dot)com>
To: pgsql-www <pgsql-www(at)lists(dot)postgresql(dot)org>
Subject: How do ordinary users grant create sequence
Date: 2023-05-09 12:20:54
Message-ID: 202305092020541566283@winhong.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-www


i have a ordinary users ,
His authority is as follows
-- 授予使用 SCHEMA的权限
GRANT USAGE on SCHEMA powerjob to powerjob ;

-- 赋予读写权限
GRANT select,insert,update,delete ON ALL TABLES IN SCHEMA powerjob to powerjob;

-- 赋予序列权限
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA powerjob to powerjob;

-- 赋予默认权限 不然后面新建的会没有权限
ALTER DEFAULT PRIVILEGES IN SCHEMA powerjob GRANT select,insert,update,delete ON TABLES TO powerjob;

-- 赋予序列权限
ALTER DEFAULT PRIVILEGES IN SCHEMA powerjob GRANT ALL PRIVILEGES ON SEQUENCES TO powerjob;

When I use it to create sequences ,
I don't have permission
Because my app has permission to automatically create sequences,
What other way is there to do it than to ask the administrator to let me create it because my app needs to trigger to start creating the sequence and if you give it to the administrator directly then this app has too much power

jiangcj(at)winhong(dot)com

Browse pgsql-www by date

  From Date Subject
Next Message Richard Guo 2023-05-10 03:14:02 Wiki editor request
Previous Message Joe Conway 2023-05-04 12:17:53 Re: Wiki editor request