SET SESSION AUTHORIZATION

NAME
SYNOPSIS
DESCRIPTION æè¿°
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
è¯è
è·

---

NAME

SET SESSION AUTHORIZATION - 为å½åä¼è¯è®¾ç½®ä¼è¯ç¨æ·æ è¯ç¬¦åå½åç¨æ·æ è¯ç¬¦

SYNOPSIS

SET [ SESSION | LOCAL ] SESSION AUTHORIZATION username
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT
RESET SESSION AUTHORIZATION

DESCRIPTION æè¿°

è¿æ¡å½ä»¤æå½å SQL ä¼è¯ç¯å¢éçä¼è¯ç¨æ·æ è¯åå½åç¨æ·æ è¯è®¾ç½®ä¸º usernameã è¿ä¸ªç¨æ·åå¯ä»¥åæä¸ä¸ªæ è¯ç¬¦æèä¸ä¸ªå串ææ¬ã 使ç¨è¿ä¸ªå½ä»¤ï¼æ们å¯ä»¥ä¸´æ¶åæä¸ä¸ªéç¹æç¨æ·ï¼ç¨åååæ¢åè¶çº§ç¨æ·ã

ä¼è¯ç¨æ·æ è¯ç¬¦ä¸å¼å§è®¾ç½®ä¸ºï¼å¯è½ç»è¿è®¤è¯çï¼å®¢æ·ç«¯æä¾çç¨æ·åã å½åç¨æ·æ è¯ç¬¦é常çäºä¼è¯ç¨æ·æ è¯ç¬¦ï¼ ä½æ¯å¯è½å¨ "setuid" çç¯å¢éæè类似çæºå¶é临æ¶æ¹åã å½åç¨æ·æ è¯ç¬¦åæéæ£æ¥ç¸å³ã

åªæå¨åå§ä¼è¯ç¨æ·ï¼è®¤è¯äºçç¨æ·ï¼æè¶çº§ç¨æ·æéçæ¶åï¼ä¼è¯ç¨æ·æè¯ç¬¦æè½æ¹åã å¦åï¼åªæå¨æå®äºè¢«è®¤è¯çç¨æ·åçæåµä¸ï¼ç³»ç»ææ¥å该å½ä»¤ã

SESSION å LOCAL 修饰è¯åæ®é SET [set(7)] å½ä»¤éçä½ç¨ç¸åã

DEFAULT å RESET å½¢å¼éç½®ä¼è¯åå½åç¨æ·æè¯ç¬¦ä¸ºåå§è®¤è¯çç¨æ·åãè¿äºå½¢å¼å¯ä»¥ä¸ºä»»ä½ç¨æ·æ§è¡ã

EXAMPLES ä¾å

SELECT SESSION_USER, CURRENT_USER;

session_user | current_user
--------------+--------------
peter | peter

SET SESSION AUTHORIZATION ’paul’;

SELECT SESSION_USER, CURRENT_USER;

session_user | current_user
--------------+--------------
paul | paul

COMPATIBILITY å¼å®¹æ§

SQL æ åå许ä¸äºå¶å®ç表达å¼åºç°å¨ææ¬ username çä½ç½®ä¸ï¼ä¸è¿è¿ä¸ªä¸è¥¿å®éä¸å¹¶ä¸éè¦ã PostgreSQL å许æ è¯ç¬¦è¯æ³ ï¼"username"ï¼ï¼è SQL ä¸å许ã SQL ä¸å许å¨ä¸ä¸ªäºå¡çè¿ç¨ä¸ç¨è¿æ¡å½ä»¤ï¼ PostgreSQL 没æè¿ä¸ªéå¶ï¼å ä¸ºæ²¡æä»ä¹çç±ä¸å许è¿æ ·ç¨ã æ åä¸- 表示æ§è¡è¿æ¡å½ä»¤çæéè¦æ±æ¯å·ä½å®ç°å®ä¹çã

è¯è

Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>

è·

æ¬é¡µé¢ä¸æçç±ä¸æ man æå页计åæä¾ã
ä¸æ man æå页计åï¼https://github.com/man-pages-zh/manpages-zh

---