Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgreSQL PG_SHADOW View

PG_SHADOW is views its contains information about rolename and user password,user password validity,user connection limit and  Role automatically inherits privileges of roles it is a member of,detailed information about user and privilege management.

Name
Type
Description
usename
name
User name
usesysid
oid
ID of this user
usecreatedb
bool
User can create databases
usesuper
bool
User is a superuser
usecatupd
bool
User can update system catalogs. (Even a superuser cannot do this unless this column is true.)
passwd
text
Password (possibly encrypted); null if none. See pg_authid for details of how encrypted passwords are stored.
valuntil
abstime
Password expiry time (only used for password authentication)
useconfig
text[]
Session defaults for run-time configuration variables

Examples
--create the unencrypted user 
postgres=# create user u2 WITH UNENCRYPTED PASSWORD 'u2';
CREATE ROLE
--create the user with password validation time
postgres=# CREATE USER u3 WITH PASSWORD 'u3' VALID UNTIL '2017-06-06';
CREATE ROLE
--Describe the  PG_SHADOW view
postgres=# \d  PG_SHADOW
View "pg_catalog.pg_shadow"
Column | Type | Modifiers
-------------+---------+-----------
usename | name |
usesysid | oid |
usecreatedb | boolean |
usesuper | boolean |
usecatupd | boolean |
userepl | boolean |
passwd | text |
valuntil | abstime |
useconfig | text[] |
--list the user and show the users password and password validatation time
postgres=# select usename,usesysid,passwd,valuntil,useconfig from PG_SHADOW;
usename | usesysid | passwd | valuntil | useconfig
----------+----------+-------------------------------------+------------------------+-----------
postgres | 10 | md505ea766c2bc9e19f34b66114ace97598 | |
rep | 24576 | md5df2c887bcb2c49b903aa33bdbc5c2984 | |
u1 | 24583 | | |
u2 | 24584 | u2 | |
u3 | 24585 | md5dad1ef51b879799793dc38d714b97063 | 2017-06-06 00:00:00-04 |
nijam | 24586 | | |
(6 rows)

Comments

Popular posts from this blog

PostgreSQL Pgbadger Installation On Linux

PostgreSQL pgBadger

How to configure Replication Manager (repmgr) ?

Postgresql Database Tutorial android app

7 Steps to configure BDR replication in postgresql