Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit4ceb2d0

Browse files
committed
* User management commands no longer user pg_exec_query_dest -> more robust
* Let unprivileged users change their own passwords.* The password is now an Sconst in the parser, which better reflects its text datatype and alsoforces users to quote them.* If your password is NULL you won't be written to the password file, meaning you can't connectuntil you have a password set up (if you use password authentication).* When you drop a user that owns a database you get an error. The database is not gone.
1 parent2af360e commit4ceb2d0

File tree

18 files changed

+1150
-778
lines changed

18 files changed

+1150
-778
lines changed

‎doc/src/sgml/Makefile

Lines changed: 6 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
#
99
#
1010
# IDENTIFICATION
11-
# $Header: /cvsroot/pgsql/doc/src/sgml/Makefile,v 1.12 1999/12/05 20:21:59 momjian Exp $
11+
# $Header: /cvsroot/pgsql/doc/src/sgml/Makefile,v 1.13 2000/01/14 22:11:31 petere Exp $
1212
#
1313
#----------------------------------------------------------------------------
1414

@@ -85,15 +85,17 @@ APPLICATIONS= createdb.sgml createuser.sgml \
8585
psql-ref.sgml\
8686
vacuumdb.sgml
8787

88-
COMMANDS= abort.sgml alter_table.sgml alter_user.sgml\
88+
COMMANDS= abort.sgmlalter_group.sgmlalter_table.sgml alter_user.sgml\
8989
begin.sgml\
9090
close.sgml cluster.sgml commit.sgml copy.sgml\
91-
create_aggregate.sgml create_database.sgml create_function.sgml create_index.sgml\
91+
create_aggregate.sgml create_database.sgml create_function.sgml create_group.sgml\
92+
create_index.sgml\
9293
create_language.sgml create_operator.sgml create_rule.sgml create_sequence.sgml\
9394
create_table.sgml create_table_as.sgml create_trigger.sgml create_type.sgml\
9495
create_user.sgml create_view.sgml\
9596
declare.sgml delete.sgml\
96-
drop_aggregate.sgml drop_database.sgml drop_function.sgml drop_index.sgml\
97+
drop_aggregate.sgml drop_database.sgml drop_function.sgml drop_group.sgml\
98+
drop_index.sgml\
9799
drop_language.sgml drop_operator.sgml drop_rule.sgml drop_sequence.sgml\
98100
drop_table.sgml drop_trigger.sgml drop_type.sgml drop_user.sgml drop_view.sgml\
99101
explain.sgml fetch.sgml grant.sgml\

‎doc/src/sgml/ref/allfiles.sgml

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/allfiles.sgml,v 1.14 1999/12/05 20:02:42 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/allfiles.sgml,v 1.15 2000/01/14 22:11:32 petere Exp $
33
Postgres documentation
44
Complete list of usable sgml source files in this directory.
55
-->
@@ -40,6 +40,7 @@ Complete list of usable sgml source files in this directory.
4040

4141
<!-- these are in the "commands" reference chapter -->
4242
<!entity abort system "abort.sgml">
43+
<!entity alterGroup system "alter_group.sgml">
4344
<!entity alterTable system "alter_table.sgml">
4445
<!entity alterUser system "alter_user.sgml">
4546
<!entity begin system "begin.sgml">
@@ -50,6 +51,7 @@ Complete list of usable sgml source files in this directory.
5051
<!entity createAggregate system "create_aggregate.sgml">
5152
<!entity createDatabase system "create_database.sgml">
5253
<!entity createFunction system "create_function.sgml">
54+
<!entity createGroup system "create_group.sgml">
5355
<!entity createIndex system "create_index.sgml">
5456
<!entity createLanguage system "create_language.sgml">
5557
<!entity createOperator system "create_operator.sgml">
@@ -66,6 +68,7 @@ Complete list of usable sgml source files in this directory.
6668
<!entity dropAggregate system "drop_aggregate.sgml">
6769
<!entity dropDatabase system "drop_database.sgml">
6870
<!entity dropFunction system "drop_function.sgml">
71+
<!entity dropGroup system "drop_group.sgml">
6972
<!entity dropIndex system "drop_index.sgml">
7073
<!entity dropLanguage system "drop_language.sgml">
7174
<!entity dropOperator system "drop_operator.sgml">

‎doc/src/sgml/ref/alter_group.sgml

Lines changed: 162 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,162 @@
1+
<!--
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_group.sgml,v 1.1 2000/01/14 22:11:32 petere Exp $
3+
Postgres documentation
4+
-->
5+
6+
<refentry id="SQL-ALTERGROUP">
7+
<refmeta>
8+
<refentrytitle id="SQL-ALTERGROUP-title">
9+
ALTER GROUP
10+
</refentrytitle>
11+
<refmiscinfo>SQL - Language Statements</refmiscinfo>
12+
</refmeta>
13+
<refnamediv>
14+
<refname>
15+
ALTER GROUP
16+
</refname>
17+
<refpurpose>
18+
Add users to a group, remove users from a group
19+
</refpurpose>
20+
</refnamediv>
21+
<refsynopsisdiv>
22+
<refsynopsisdivinfo>
23+
<date>2000-01-14</date>
24+
</refsynopsisdivinfo>
25+
<synopsis>
26+
ALTER GROUP <replaceable class="PARAMETER">name</replaceable> ADD USER <replaceable class="PARAMETER">username</replaceable> [, ... ]
27+
ALTER GROUP <replaceable class="PARAMETER">name</replaceable> DROP USER <replaceable class="PARAMETER">username</replaceable> [, ... ]
28+
</synopsis>
29+
30+
<refsect2 id="R2-SQL-ALTERGROUP-1">
31+
<refsect2info>
32+
<date>2000-01-14</date>
33+
</refsect2info>
34+
<title>
35+
Inputs
36+
</title>
37+
38+
<para>
39+
<variablelist>
40+
<varlistentry>
41+
<term><replaceable class="PARAMETER">name</replaceable></term>
42+
<listitem>
43+
<para>
44+
The name of the group to modify.
45+
</para>
46+
</listitem>
47+
</varlistentry>
48+
49+
<varlistentry>
50+
<term><replaceable class="PARAMETER">username</replaceable></term>
51+
<listitem>
52+
<para>
53+
Users which are to be added or removed from the group. The user
54+
names must exist.
55+
</para>
56+
</listitem>
57+
</varlistentry>
58+
59+
</variablelist>
60+
</para>
61+
</refsect2>
62+
63+
<refsect2 id="R2-SQL-ALTERGROUP-2">
64+
<refsect2info>
65+
<date>2000-01-14</date>
66+
</refsect2info>
67+
<title>
68+
Outputs
69+
</title>
70+
<para>
71+
<variablelist>
72+
<varlistentry>
73+
<term><computeroutput>ALTER GROUP</computeroutput></term>
74+
<listitem>
75+
<para>
76+
Message returned if the alteration was successful.
77+
</para>
78+
</listitem>
79+
</varlistentry>
80+
81+
</variablelist>
82+
</para>
83+
</refsect2>
84+
</refsynopsisdiv>
85+
86+
<refsect1 id="R1-SQL-ALTERGROUP-1">
87+
<refsect1info>
88+
<date>2000-01-14</date>
89+
</refsect1info>
90+
<title>
91+
Description
92+
</title>
93+
<para>
94+
<command>ALTER GROUP</command> is used to change add users to a group or
95+
remove them from a group. Only database superusers can use this command.
96+
Adding a user to a group does not create the user. Similarly, removing
97+
a user from a group does not drop the user itself.
98+
</para>
99+
<para>
100+
Use <xref linkend="SQL-CREATEGROUP" endterm="SQL-CREATEGROUP-title">
101+
to create a new group and <xref linkend="SQL-DROPGROUP"
102+
endterm="SQL-DROPGROUP-title"> to remove a group.
103+
</para>
104+
</refsect1>
105+
106+
<refsect1 id="R1-SQL-ALTERGROUP-2">
107+
<title>
108+
Usage
109+
</title>
110+
<para>
111+
Add users to a group:
112+
113+
<programlisting>
114+
ALTER GROUP staff ADD USER karl, john
115+
</programlisting>
116+
117+
Remove a user from a group
118+
119+
<programlisting>
120+
ALTER GROUP workers DROP USER beth
121+
</programlisting>
122+
123+
</para>
124+
</refsect1>
125+
126+
<refsect1 id="R1-SQL-ALTERGROUP-3">
127+
<title>
128+
Compatibility
129+
</title>
130+
131+
<refsect2 id="R2-SQL-ALTERGROUP-4">
132+
<refsect2info>
133+
<date>2000-01-14</date>
134+
</refsect2info>
135+
<title>
136+
SQL92
137+
</title>
138+
<para>
139+
There is no <command>ALTER GROUP</command> statement in
140+
<acronym>SQL92</acronym>. The concept of roles is
141+
similar.
142+
</para>
143+
</refsect2>
144+
</refsect1>
145+
</refentry>
146+
147+
<!-- Keep this comment at the end of the file
148+
Local variables:
149+
mode: sgml
150+
sgml-omittag:nil
151+
sgml-shorttag:t
152+
sgml-minimize-attributes:nil
153+
sgml-always-quote-attributes:t
154+
sgml-indent-step:1
155+
sgml-indent-data:t
156+
sgml-parent-document:nil
157+
sgml-default-dtd-file:"../reference.ced"
158+
sgml-exposed-tags:nil
159+
sgml-local-catalogs:"/usr/lib/sgml/catalog"
160+
sgml-local-ecat-files:nil
161+
End:
162+
-->

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp