~ubuntu-branches/ubuntu/oneiric/postgresql-9.1/oneiric-security

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/sql-drop-owned.html

  • Committer: Package Import Robot
  • Author(s): Martin Pitt
  • Date: 2013-02-05 18:13:52 UTC
  • mfrom: (1.1.10) (10.1.5 oneiric-proposed)
  • Revision ID: package-import@ubuntu.com-20130205181352-3kw4f94ilqklzm7c
Tags: 9.1.8-0ubuntu11.10
* New upstream security/bug fix release: (LP: #1116336)
  - Prevent execution of enum_recv from SQL
    The function was misdeclared, allowing a simple SQL command to crash the
    server.  In principle an attacker might be able to use it to examine the
    contents of server memory.  Our thanks to Sumit Soni (via Secunia SVCRP)
    for reporting this issue. (CVE-2013-0255)
  - See HISTORY/changelog.gz for the other bug fixes.

Show diffs side-by-side

added added

removed removed

Lines of Context:
9
9
REV="MADE"
10
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
11
11
REL="HOME"
12
 
TITLE="PostgreSQL 9.1.5 Documentation"
 
12
TITLE="PostgreSQL 9.1.8 Documentation"
13
13
HREF="index.html"><LINK
14
14
REL="UP"
15
15
TITLE="SQL Commands"
26
26
HTTP-EQUIV="Content-Type"
27
27
CONTENT="text/html; charset=ISO-8859-1"><META
28
28
NAME="creation"
29
 
CONTENT="2012-08-14T22:55:48"></HEAD
 
29
CONTENT="2013-02-04T21:38:53"></HEAD
30
30
><BODY
31
31
CLASS="REFENTRY"
32
32
><DIV
44
44
VALIGN="bottom"
45
45
><A
46
46
HREF="index.html"
47
 
>PostgreSQL 9.1.5 Documentation</A
 
47
>PostgreSQL 9.1.8 Documentation</A
48
48
></TH
49
49
></TR
50
50
><TR
95
95
><DIV
96
96
CLASS="REFNAMEDIV"
97
97
><A
98
 
NAME="AEN71018"
 
98
NAME="AEN71053"
99
99
></A
100
100
><H2
101
101
>Name</H2
103
103
><DIV
104
104
CLASS="REFSYNOPSISDIV"
105
105
><A
106
 
NAME="AEN71023"
 
106
NAME="AEN71058"
107
107
></A
108
108
><H2
109
109
>Synopsis</H2
119
119
><DIV
120
120
CLASS="REFSECT1"
121
121
><A
122
 
NAME="AEN71026"
 
122
NAME="AEN71061"
123
123
></A
124
124
><H2
125
125
>Description</H2
127
127
>   <TT
128
128
CLASS="COMMAND"
129
129
>DROP OWNED</TT
130
 
> drops all the objects in the current
 
130
> drops all the objects within the current
131
131
   database that are owned by one of the specified roles. Any
132
132
   privileges granted to the given roles on objects in the current
133
 
   database will also be revoked.
 
133
   database and on shared objects (databases, tablespaces) will also be
 
134
   revoked.
134
135
  </P
135
136
></DIV
136
137
><DIV
137
138
CLASS="REFSECT1"
138
139
><A
139
 
NAME="AEN71030"
 
140
NAME="AEN71065"
140
141
></A
141
142
><H2
142
143
>Parameters</H2
185
186
><DIV
186
187
CLASS="REFSECT1"
187
188
><A
188
 
NAME="AEN71048"
 
189
NAME="AEN71083"
189
190
></A
190
191
><H2
191
192
>Notes</H2
218
219
   more roles.
219
220
  </P
220
221
><P
221
 
>   Databases owned by the role(s) will not be removed.
 
222
>   Databases and tablespaces owned by the role(s) will not be removed.
222
223
  </P
223
224
></DIV
224
225
><DIV
225
226
CLASS="REFSECT1"
226
227
><A
227
 
NAME="AEN71058"
 
228
NAME="AEN71093"
228
229
></A
229
230
><H2
230
231
>Compatibility</H2
242
243
><DIV
243
244
CLASS="REFSECT1"
244
245
><A
245
 
NAME="AEN71063"
 
246
NAME="AEN71098"
246
247
></A
247
248
><H2
248
249
>See Also</H2