Postgres users question

[pgosse]

Hi there. I've got a question about user managment in PostgreSQL.

I've got a set of 7 web applications which I wrote with PHP/MySQL and now I need to port them to PostgreSQL. I'm using PHPPGAdmin to admin the db.

I have several different users that access different sections of the database. With MySQL I defined the amount of access the users had on their respective tables (select, insert, update, delete, etc), but with PostgreSQL I'm unable to find such options. All I see is the ability to set whether the new user should be able to create new users or databases, and when it should expire.

Am I missing something here? Shouldn't there be a way to limit the access each user has? I've tried the following:

GRANT Select, Insert, Update, Delete ON DB.TABLENAME TO 'user'@'SERVERNAME' IDENTIFIED BY 'userpass'

which is what I'd use in MySQL but it just gives errors.

Can anybody help me with this?

Thanks,
Pablo

[Anon]

You can - just the syntax is wrong.

GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER }
[,...] | ALL [ PRIVILEGES ] }
ON [ TABLE ] tablename [, ...]
TO { username | GROUP groupname | PUBLIC } [, ...]

http://developer.postgresql.org/docs/postgres/sql-grant.html