1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
8 CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
10 HREF="mailto:pgsql-docs@postgresql.org"><LINK
12 TITLE="PostgreSQL 7.4.1 Documentation"
13 HREF="index.html"><LINK
15 TITLE="System Catalogs"
16 HREF="catalogs.html"><LINK
19 HREF="catalog-pg-rewrite.html"><LINK
22 HREF="catalog-pg-statistic.html"><LINK
25 HREF="stylesheet.css"><META
27 CONTENT="2003-12-22T03:48:47"></HEAD
33 SUMMARY="Header navigation table"
43 >PostgreSQL 7.4.1 Documentation</TH
51 HREF="catalog-pg-rewrite.html"
67 >Chapter 43. System Catalogs</TD
81 HREF="catalog-pg-statistic.html"
95 NAME="CATALOG-PG-SHADOW"
108 > contains information about
109 database users. The name stems from the fact that this table
110 should not be readable by the public since it contains passwords.
112 HREF="view-pg-user.html"
118 is a publicly readable view on
122 > that blanks out the password field.
126 HREF="user-manag.html"
128 > contains detailed information about user and
129 privilege management.
132 > Because user identities are cluster-wide,
137 is shared across all databases of a cluster: there is only one
159 ><COL><COL><COL><COL><THEAD
202 >User id (arbitrary number used to reference this user)</TD
218 >User may create databases</TD
234 >User is a superuser</TD
250 > User may update system catalogs. (Even a superuser may not do
251 this unless this column is true.)
284 >Account expiry time (only used for password authentication)</TD
300 >Session defaults for run-time configuration variables</TD
311 SUMMARY="Footer navigation table"
322 HREF="catalog-pg-rewrite.html"
340 HREF="catalog-pg-statistic.html"