¾�ΥС��ʸ�� 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9.6 | 9.5 | 9.4 | 9.3 | 9.2 | 9.1 | 9.0 | 8.4 | 8.3 | 8.2 | 8.1 | 8.0 | 7.4 | 7.3 | 7.2

PostgreSQL 9.2.4ʸ��
前のページ	上に戻る		次のページ

ALTER USER MAPPING

名前

ALTER USER MAPPING -- �桼��ޥåפ��ѹ��

概要

ALTER USER MAPPING FOR { user_name | USER | CURRENT_USER | PUBLIC }
    SERVER server_name
    OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )

��

ALTER USER MAPPING�ϥ桼��ޥåפ��ѹ��ޤ��

��Фν�ͭ�Ԥ�Ǥ�դΥ桼��Ф��뤽�Υ��и��Υ桼��ޥåפ��ѹ��뤳�Ȥ��Ǥ��ޤ�� ޤ��о��USAGE��¤��桼��Ϳ��Ƥ��硢�桼��ϼ��Ȥλ��ĥ桼��̾��б��桼��ޥåפ��ѹ��뤳�Ȥ��Ǥ��ޤ��

�ѥ�᡼��

user_name: �б��դ��桼��̾�Ǥ�� CURRENT_USER��USER�ϸ��ߤΥ桼��̾�˰��פ��ޤ�� PUBLIC�ϸ��ߤ��Ӿ��˥��ƥ��¸�ߤ��뤹�٤ƤΥ桼��˰��פ��뤿��˻��Ѥ��ޤ��
server_name: �桼��ޥåפΥ��̾�Ǥ��
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ): �桼��ޥåפΥ��ץ��ѹ��ޤ�� ץ��ϲ��˻��ꤵ�줿��ץ��򤹤٤ƾ�񤭤��ޤ�� ADD��SET��DROP�ϼ¹Ԥ��ư��ꤷ�ޤ�� Ū��ư��꤬�ʤ��硢ADD�Ȥߤʤ��ޤ�� ץ��̾�ϰ�դǤʤ��Фʤ�ޤ�� ޤ��ץ��ϥ��Фγ��ǡ��åѤˤ�긡�ڤ��ޤ��

��

��foo�Υ桼��ޥå�bob�Υѥ���ɤ��ѹ��ޤ��

ALTER USER MAPPING FOR bob SERVER foo OPTIONS (user 'bob', password 'public');

�ߴ��

ALTER USER MAPPING��ISO/IEC 9075-9(SQL/MED)�˽��ޤ�� ʹ�ʸ��꤬��ޤ�� ɸ��Ǥ�FOR���ɤ��ά��ޤ�� CREATE USER MAPPING��DROP USER MAPPING�Ǥ�FOR��褦�ʰ��֤ǻ��Ѥ��ޤ�IBM DB2��¾�μ��SQL/MED��ˤʤäƤ��ޤ��ˤǤ�ALTER USER MAPPING��ɬ�פȤ��Ƥ��ޤ��Τǡ�PostgreSQL�ϡ��߱��Ū�ˡ�ɸ��Ȱ㤤��Ƥ��ޤ��

��Ϣ��

CREATE USER MAPPING, DROP USER MAPPING

前のページ	ホーム	次のページ
ALTER USER	上に戻る	ALTER VIEW