| From: | Shams Khan <shams(dot)khan22(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | User creation |
| Date: | 2012-10-19 07:14:33 |
| Message-ID: | CAM42boo5bqSJJHWZgr3eKJ1_qFL_sySfn4tP7Qf2jZU7wiAFCg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | raghu ram | 2012-10-19 08:40:21 | Streaming Replication Server Crash |
| Previous Message | teyking2003 | 2012-10-19 05:55:26 | Re: Database in psql |