| 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: | Whole Thread | Raw Message | 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 |