Postgres Pro
Downloads
Home   >   mailing lists

user restriction - Mailing list pgsql-general

From Ashish Karalkar
Subject user restriction
Date
Msg-id 009a01c7a410$1462a6b0$170211ac@LIONKING.COM
Whole thread Raw
Responses Re: user restriction  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view

Hi All,

 

I want to create a user in Postgres Database. And I want to restrict that user with some privileges. And also I want that user should be specific to particular database.

He should not be able to do the following

1)       Connect to any other database.

2)       Connect to System database (like Postgres).

 

He should only be able to connect to Specific Database & perform those activities which has been granted.

pgsql-general by date:

Previous
From: Dudás József
Date:
Subject: Re: invalid memory alloc after insert with c trigger function
Next
From: Vincenzo Romano
Date:
Subject: Re: Numeric performances