newbie : setting access for users in a web enviroment

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.

Responses

Browse pgsql-general by date

  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