From: | robert mena <robert(dot)mena(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | newbie : setting access for users in a web enviroment |
Date: | 2005-12-23 21:06:40 |
Message-ID: | 528f47680512231306m14252e04w6392863b668f81f@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I am new to postgres but coming from a MySQL enviroment.
I am confused with the necessary steps to create users and restrict them to
access/delete/insert/update data and create/delete/alter tables in a
specific database.
I've created a database test and a user testadm
createdb test
createuser -D -P testadm
Enter password for new user:
Enter it again:
Shall the new user be allowed to create more new users? (y/n) n
CREATE USER
psql test
\du
List of users
User name | User ID | Attributes | Groups
----------------+---------+----------------------------+--------
testadm | 100 | |
postgres | 1 | superuser, create database |
GRANT CREATE,REFERENCES ON DATABASE test TO testadm;
\z
Access privileges for database "test"
Schema | Name | Type | Access privileges
--------+------+------+-------------------
How can I specify that the user testadm can perform those actions to this
database?
Tks.
From | Date | Subject | |
---|---|---|---|
Next Message | Qingqing Zhou | 2005-12-23 21:31:03 | Re: newbie : setting access for users in a web enviroment |
Previous Message | S McLurkin | 2005-12-23 19:24:58 | Re: contrib extenstions |