Обсуждение: User creation
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...
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...
On Fri, Oct 19, 2012 at 1:14 AM, Shams Khan <shams.khan22@gmail.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.