Thread: users rights per table

users rights per table

From
victor
Date:
     I have to implement a structure of rights.
     I'm intrested if postgresql can restrict these operations(insert, update, select, delete) for a specified postgresql user.
     If this is possible, please tell me were could I find some documentation about this subject.
    
    Thank you.

Re: users rights per table

From
Mike Nolan
Date:
>      I have to implement a structure of rights.
>      I'm intrested if postgresql can restrict these operations(insert,
> update, select, delete) for a specified postgresql user.
>      If this is possible, please tell me were could I find some
> documentation about this subject.

Can we assume that you have not yet read the section on 'GRANT'
in the online documentation on the postgreSQL website?
--
Mike Nolan

Re: users rights per table

From
Peter Eisentraut
Date:
victor wrote:
>      I have to implement a structure of rights.
>      I'm intrested if postgresql can restrict these
> operations(insert, update, select, delete) for a specified postgresql
> user.
>      If this is possible, please tell me were could I find some
> documentation about this subject.

Read the reference page of GRANT.