[Babase] Granting permissions to tables in PPA
Karl O. Pinc
kop at meme.com
Wed Mar 7 13:41:25 EST 2007
On 03/07/2007 10:11:17 AM, Lacey Maryott wrote:
> Good morning Karl,
> Leah and I have been working on updating the Wiki with information
> about granting permissions to tables and we would like to clarify the
> difference between the following statements:
>
> grant all on sandbox.tablename to group babase_editors;
This allowes the babase_editors group of people, those people
who are allowed to change the data in tables, the right
to change the data in the table. That means insert,
update, and delete. It also gives them the right
to look at the data with select.
>
> grant select on sandbox.tablename to group babase_readers;
This lets those people who can see babase data look
at the content of the new table.
>
> Can you tell us what the difference between the two is? Thanks so much
See:
https://papio.biology.duke.edu/babase_system_html/ch02s02.html
http://www.postgresql.org/docs/8.1/static/sql-grant.html
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list