Difference between revisions of "SET SESSION AUTHORIZATION"
Jump to navigation
Jump to search
| (6 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | *https://www.postgresql.org/docs/current/sql-set-session-authorization.html | + | * https://www.postgresql.org/docs/current/sql-set-session-authorization.html |
| + | |||
| + | [[SET SESSION]] AUTHORIZATION user_name | ||
| + | |||
| + | Output: | ||
| + | SET | ||
| + | |||
| + | |||
| + | SELECT SESSION_USER, CURRENT_USER; | ||
| + | |||
| − | |||
== Related == | == Related == | ||
| Line 7: | Line 15: | ||
== See also == | == See also == | ||
| + | * {{Redshift}} | ||
* {{PostgreSQL}} | * {{PostgreSQL}} | ||
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
[[Category:RedShift]] | [[Category:RedShift]] | ||
Latest revision as of 10:18, 22 September 2022
SET SESSION AUTHORIZATION user_name Output: SET
SELECT SESSION_USER, CURRENT_USER;
Related[edit]
See also[edit]
- Amazon Redshift,
aws redshift, Amazon Redshift query editor, GRANT, AQUA,has schema privilege, WLM, Amazon Redshift Spectrum, metrics, VACUUM, SET - PostgreSQL:
pg_dump, pg_restore,pgAdmin, pg_config, psql, pg_ctl, pg_isready, initdb, Role, Schema, DBeaver, Navicat, DataGrip, OmniDB,Adminer, docker-compose.xml PostgreSQL, PostgreSQL version, PostgreSQL logs,postgresql.conf,pg_hba.conf, $HOME/.pg_service.conf, Create database (PostgreSQL), Create user,createdb,GRANT,pg_stat, PostgreSQL VACUUM, EXPLAIN,pg stat activity, Autovacuum, ALTER DATABASE, PostgreSQL statistics collector, Shared buffers, EXPLAIN (PostgreSQL),EXPLAIN ANALYZE, Bitmap scan,EXPLAIN VERBOSE,EXPLAIN VERBOSE (PostgresSQL),WAL,ALTER USER,CREATE ROLE, CREATE USER,\du,show users,\l, The Statistics Collector, pganalyze,cron.schedule, Master,pg_tables, PostgreSQL replication,CREATE, SET, TOAST, PgBouncer, Restore DB, Index, meta-commands, Table, foreign table, Schema, Sequence, Views, materialized view, Table Partitioning, monitoring, PostgreSQL System Administration Functions, PostgreSQL extension, privileges, logging, PGTune, PostgreSQL parameter tunning, PostgreSQL modules, pgbench, PostgreSQL users
Advertising:
