[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