Postgres Pro
Downloads
Home   >   mailing lists

Re: How to Add User with Select Priviliges only - Mailing list pgsql-novice

From raghu ram
Subject Re: How to Add User with Select Priviliges only
Date
Msg-id CALnrrJSnMTACJU7C0JFJEh_Jea9O=PxE5Fdm0avtFzCj21a4uw@mail.gmail.com
Whole thread Raw
In response to How to Add User with Select Priviliges only  ("Bedorf, Paul" <Paul.Bedorf@mosaic.com>)
List pgsql-novice
Tree view


On Wed, Jun 27, 2012 at 12:52 AM, Bedorf, Paul <Paul.Bedorf@mosaic.com> wrote:

Hi, I am new to Postgres SQL and have a task to add a user that will have permissions only to select from the database but not make any changes etc...

I do not know how to do that, can anyone provide instructions?

I have the following databases:

Name | Owner |
------------+----------+
mpower_dev | mpower |
postgres | postgres |
template0 | postgres |
template1 | postgres

I would like to grant the select only provileges to the new user on the mpower_dev database.


Use below command to provide READ-ONLY user access for all tables available in schema:

Grant select on all tables in schema <schema_name> to <username>; 


--

Thanks & Regards,

Raghu Ram



pgsql-novice by date:

Previous
From: Jayadevan M
Date:
Subject: Re: How to Add User with Select Priviliges only
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #6711: how to run sql query by command prompt in postgres sql