要在PostgreSQL中創(chuàng)建用戶并授予權(quán)限,可以按照以下步驟操作:
sudo -u postgres psql
CREATE ROLE new_user WITH LOGIN PASSWORD 'password';
GRANT CONNECT ON DATABASE database_name TO new_user;
GRANT ALL PRIVILEGES ON DATABASE database_name TO new_user;
GRANT SELECT, INSERT, UPDATE, DELETE ON table_name TO new_user;
ALTER ROLE new_user CREATEDB;
\q
現(xiàn)在新用戶已經(jīng)創(chuàng)建并授予權(quán)限。可以使用新用戶登錄到PostgreSQL數(shù)據(jù)庫,并執(zhí)行相應(yīng)的操作。