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

Oracle DBMS SCHEDULER Examples

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

vacuumlo - removing large objects orphans from a database PostgreSQL