PostgreSQL PG_AUTHID VIEW
PG_AUTHID 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 rolname name Role name rolsuper bool Role has superuser privileges rolinherit bool Role automatically inherits privileges of roles it is a member of rolcreaterole bool Role can create more roles rolcreatedb bool Role can create databases rolcatupdate bool Role can update system catalogs directly. (Even a superuser cannot do this unless this column is true) rolcanlogin bool Role can log in. That is, this role can be given as the initial session authorization identifier rolreplication bool Role is a replication role. That is, this role can initiate streaming replication and set/...