From: | raghu ram <raghuchennuru(at)gmail(dot)com> |
---|---|
To: | "Bedorf, Paul" <Paul(dot)Bedorf(at)mosaic(dot)com> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: How to Add User with Select Priviliges only |
Date: | 2012-06-27 09:47:46 |
Message-ID: | CALnrrJSnMTACJU7C0JFJEh_Jea9O=PxE5Fdm0avtFzCj21a4uw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, Jun 27, 2012 at 12:52 AM, Bedorf, Paul <Paul(dot)Bedorf(at)mosaic(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | kapilkumar04 | 2012-06-27 11:17:16 | BUG #6711: how to run sql query by command prompt in postgres sql |
Previous Message | Jayadevan M | 2012-06-27 03:10:57 | Re: How to Add User with Select Priviliges only |