1.创建用户(用户或角色) testdb=# CREATE USER test WITH PASSWORD '123';; CREATE ROLE 2. 赋予超级用户权限 testdb=# ALTER USER test WITH SUPERUSER; ALTER ROLE 3. 取消超级用户权限 testdb=# ALTER USER test WITH NOSUPERUSER; ALTER ROLE