From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Shams Khan <shams(dot)khan22(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: User creation |
Date: | 2012-10-19 17:53:08 |
Message-ID: | CAOR=d=2KkdpRaSON_GjpxswW7Td2yanb-Sp=ZFYigsCiLc8JbQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Fri, Oct 19, 2012 at 1:14 AM, Shams Khan <shams(dot)khan22(at)gmail(dot)com> wrote:
> Hi Experts,
>
> I am new to postgresql, just wanted to know more about user creation.
>
> I tried to create users using command [create user sam] without any option]
> what are the default rights given to the user?
>
> radius=> select * from pg_user;
> usename | usesysid | usecreatedb | usesuper | usecatupd | userepl |
> passwd | valuntil | useconfig
> ----------+----------+-------------+----------+-----------+---------+----------+----------+-----------
> postgres | 10 | t | t | t | t |
> ******** | |
> radius | 9479531 | f | t | t | t |
> ******** | |
> sam | 9492031 | f | f | f | f |
> ******** | |
>
> what doest 't' and 'f' denotes here?? just want to clarify...
They're bool fields, so t and f denote true or false. I.e. a new user
with no flags set during creation gets all of those false.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2012-10-19 18:10:19 | Re: Auto Vacuum |
Previous Message | Scott Marlowe | 2012-10-19 17:49:23 | Re: Auto Vacuum |