• Home
  • Services
    • HR Services
      • HR Advisory Services
      • Contract Staffing
      • HR Outsourcing Services
      • Manpower Supply Services
      • Payroll Processing
      • Permanent Placement
      • Recruitment and Placement Services
      • Recruitment Process Outsourcing
      • Staffing Agency Services
    • DBA Support
      • DBA Consultancy Services
      • PostgreSQL Support
    • Website Maintenance
    • Company Registration Services
    • Virtual Office Space Address
  • Company
    • FAQs
    • About Us
    • Contact
  • Locations
  • Blogs
    • Blog
    • Blog – PostgreSQL Support
    • Blog – PostgreSQL Migration
    • Blog – All DB’s
    • Blog – Linux
  • Courses

    About Courses

    • List Of Courses
    • Become an Instructor
    Greenplum

    Greenplum

    $1,500.00
    Read More
    Have any question?
    (+91)8838953252
    ITsupport@rayafeel.com
    Login
    RayaFeeL
    • Home
    • Services
      • HR Services
        • HR Advisory Services
        • Contract Staffing
        • HR Outsourcing Services
        • Manpower Supply Services
        • Payroll Processing
        • Permanent Placement
        • Recruitment and Placement Services
        • Recruitment Process Outsourcing
        • Staffing Agency Services
      • DBA Support
        • DBA Consultancy Services
        • PostgreSQL Support
      • Website Maintenance
      • Company Registration Services
      • Virtual Office Space Address
    • Company
      • FAQs
      • About Us
      • Contact
    • Locations
    • Blogs
      • Blog
      • Blog – PostgreSQL Support
      • Blog – PostgreSQL Migration
      • Blog – All DB’s
      • Blog – Linux
    • Courses

      About Courses

      • List Of Courses
      • Become an Instructor
      Greenplum

      Greenplum

      $1,500.00
      Read More

      Blog

      • Home
      • Blog
      • Blog
      • PostgreSQL PG_AUTHID system catalog VIEW

      PostgreSQL PG_AUTHID system catalog VIEW

      • Posted by Nijamutheen J
      • Categories Blog
      • Date October 14, 2018
      • Comments 0 comment

      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/unset the system backup mode usingpg_start_backup and pg_stop_backup
      rolconnlimit int4 For roles that can log in, this sets maximum number of concurrent connections this role can make. -1 means no limit.
      rolpassword text Password (possibly encrypted); null if none. If the password is encrypted, this column will begin with the string md5 followed by a 32-character hexadecimal MD5 hash. The MD5 hash will be of the user’s password concatenated to their user name. For example, if user joe has password xyzzy, PostgreSQL will store the md5 hash of xyzzyjoe. A password that does not follow that format is assumed to be unencrypted.
      rolvaliduntil timestamptz Password expiry time (only used for password authentication); null if no expiration

      Examples

      –create the unencrypted user 

      create user u2 WITH UNENCRYPTED PASSWORD 'u2';

      –create the user with password validation time

      CREATE USER u3 WITH PASSWORD 'u3' VALID UNTIL '2017-06-06';

      –Describe the pg_authid view

      postgres=# \d  pg_authid
                   Table "pg_catalog.pg_authid"
           Column     |           Type           | Modifiers 
      ----------------+--------------------------+-----------
       rolname        | name                     | not null
       rolsuper       | boolean                  | not null
       rolinherit     | boolean                  | not null
       rolcreaterole  | boolean                  | not null
       rolcreatedb    | boolean                  | not null
       rolcatupdate   | boolean                  | not null
       rolcanlogin    | boolean                  | not null
       rolreplication | boolean                  | not null
       rolconnlimit   | integer                  | not null
       rolpassword    | text                     | 
       rolvaliduntil  | timestamp with time zone | 
      Indexes:
          "pg_authid_oid_index" UNIQUE, btree (oid), tablespace "pg_global"
          "pg_authid_rolname_index" UNIQUE, btree (rolname), tablespace "pg_global"
      Tablespace: "pg_global"

      –list the user and show the users password and password validatation time

      postgres=# select rolname,rolpassword,rolvaliduntil from pg_authid;                      
       rolname  |             rolpassword             |     rolvaliduntil      
      ----------+-------------------------------------+------------------------
       postgres | md505ea766c2bc9e19f34b66114ace97598 | 
       rep      | md5df2c887bcb2c49b903aa33bdbc5c2984 | 
       u1       |                                     | 
       u2       | u2                                  | 
       u3       | md5dad1ef51b879799793dc38d714b97063 | 2017-06-06 00:00:00-04
      (5 rows)

      • Share:
      Nijamutheen J
      Nijamutheen J

      Nijamutheen J 7+ years of experience in PostgreSQL, Linux admin , web hosting - apache server , Oracle ,mySQL, Mriadb, vertica DB & Server security administrator

      My updated resume is https://www.tutorialdba.com/p/hi-i-have-4.html

      Previous post

      Oracle to PostgreSQL Migration with open source tools
      October 14, 2018

      Next post

      PostgreSQL PG_SHADOW
      October 14, 2018

      Leave A Reply

      You must be logged in to post a comment.

      Connect with



      Search

      ADVERTISEMENT

      Latest Posts

      Tips to Choose the Best Serviced Office for Your Business
      24May2022
      What key considerations do you need to keep in mind when choosing a new serviced office to house your business?
      24May2022
      The Benefits of Coworking
      24May2022
      The Long-Term Impact of Coworking
      24May2022
      Are you spending more money than you earn? Outsource with Ease and Move When You’re Ready
      24May2022
      PostgreSQL

      PostgreSQL

      $800.00 $500.00
      Greenplum

      Greenplum

      $1,500.00
      Oracle Database

      Oracle Database

      $350.00
      2ndquadrant.in

      (+91) 8838953252

      ITsupport@rayafeel.com

      Company

      • About Us
      • Our Team

      COURSES

      • List Of Course
      • Become An Instructor

      Support

      • DBA Support
      • Consultancy Services

      Recommend

      • Login
      • Contact Us

      IT Services by rayafeel.com. Powered by Rayafeel Technologies Pvt Ltd.

      • Privacy
      • Terms

      Become An Instructor?

      Join thousand of instructors and earn money hassle free!

      Get Started Now

      Connect with

      Login with Google Login with Twitter Login with Linkedin Login with Windowslive Login with Yahoo

      Login with your site account

      Connect with



      Lost your password?