DBA Hub

📋Steps in this guide1/1

Convert a user to superuser

-- providing superuser role will make an user superuser.

postgresql configurationintermediate
by PostgreSQL
12 views
1

Convert a user to superuser

-- providing superuser role will make an user superuser. -- How to revoke superuser:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
postgres=#
select usename,usesuper from pg_user where usename='dbatest';
usename  | usesuper
---------+----------
dbatest  | f
(1 row)
postgres=#
postgres=#
alter user dbatest with superuser;
ALTER ROLE
postgres=#
select usename,usesuper from pg_user where usename='dbatest';
usename  | usesuper
---------+----------
dbatest  | t
postgres=#
alter user dbatest with nosuperuser;
ALTER ROLE
postgres=#
postgres=#
select usename,usesuper from pg_user where usename='dbatest';
usename  | usesuper
---------+----------
dbatest  | f
(1 row)

Comments (0)

Please to add comments

No comments yet. Be the first to comment!