Search “set_role” — BetterMan

Search

Tip: Use ssh_config or systemd.unit for dotted names.

Did you mean: set, drop_role, alter_role, fd_set?

set the current user identifier of the current session

NAME SET_ROLE - set the current user identifier of the current session SYNOPSIS SET [ SESSION ... identifier or a string literal. After SET ROLE , permissions checking for SQL comm…

grant(7)

define access privileges

granted role using the SET ROLE command. If a role is an indirect member ... another role, it can use SET ROLE to change to that role only if there

create_role(7)

define a new database role

member role would be able to SET ROLE to the createdb role and then create ... GROUP role_name [, ...] SEE ALSO SET ROLE ( SET_ROLE (7)), ALTER ROLE ( ALTER_ROLE

set_session_authorization(7)

set the session user identifier and the current user identifier of the current session

also be changed by SET ROLE . The current user identifier is relevant for permission checking ... defined by the standard. SEE ALSO SET ROLE ( SET_ROLE

drop_role(7)

remove a database role

ALTER ROLE ( ALTER_ROLE (7)), SET ROLE ( SET_ROLE

alter_role(7)

change a database role

only happens at login time; executing SET ROLE or SET SESSION AUTHORIZATION does not cause ... settings take effect only at login; SET ROLE and SET SESSION AUTHORIZATION do not pro…

alter_server(7)

change the definition of a foreign server

owner, you must be able to SET ROLE to the new owning role

alter_sequence(7)

change the definition of a sequence generator

owner, you must be able to SET ROLE to the new owning role, and that

chcon(1)

change file security context

target security context -r , --role = ROLE set role ROLE in the target security context

revoke(7)

remove access privileges

best practice to use SET ROLE to become the specific role you want

pg_restore(1)

restore a PostgreSQL database from an archive file created by pg_dump

causes pg_restore to issue a SET ROLE rolename command after connecting to the database

alter_table(7)

change the definition of a table

owner, you must be able to SET ROLE to the new owning role, and that

alter_schema(7)

change the definition of a schema

owner, you must be able to SET ROLE to the new owning role, and that

create_schema(7)

define a new schema

role, you must be able to SET ROLE to that role. schema_element

alter_statistics(7)
change the definition of an extended statistics object
```
owner, you must be able to SET ROLE to the new owning role, and that
```
alter_subscription(7)
change the definition of a subscription
```
owner, you must be able to SET ROLE to the new owning role
```

alter_foreign_table(7)

change the definition of a foreign table

owner, you must be able to SET ROLE to the new owning role, and that

pg_dumpall(1)

extract a PostgreSQL database cluster into a script file

causes pg_dumpall to issue a SET ROLE rolename command after connecting to the database

pg_dump(1)

extract a PostgreSQL database into a script file or other archive file

causes pg_dump to issue a SET ROLE rolename command after connecting to the database

alter_view(7)

change the definition of a view

owner, you must be able to SET ROLE to the new owning role, and that

20 results loaded