From: <vga...@us...> - 2010-03-16 20:03:37
|
Revision: 612 http://treebase.svn.sourceforge.net/treebase/?rev=612&view=rev Author: vgapeyev Date: 2010-03-16 20:03:30 +0000 (Tue, 16 Mar 2010) Log Message: ----------- Correct privileges on a sequence. Added Paths: ----------- trunk/treebase-core/db/cleaning/2010-03-12_stepmatrixelement_seq_priveleges/ trunk/treebase-core/db/cleaning/2010-03-12_stepmatrixelement_seq_priveleges/README trunk/treebase-core/db/cleaning/2010-03-12_stepmatrixelement_seq_priveleges/stepmatrixelement_seq_priveleges.sql Added: trunk/treebase-core/db/cleaning/2010-03-12_stepmatrixelement_seq_priveleges/README =================================================================== --- trunk/treebase-core/db/cleaning/2010-03-12_stepmatrixelement_seq_priveleges/README (rev 0) +++ trunk/treebase-core/db/cleaning/2010-03-12_stepmatrixelement_seq_priveleges/README 2010-03-16 20:03:30 UTC (rev 612) @@ -0,0 +1 @@ +Was applied to treebasedev and treebasestage by postgres (Jon) on 2010-03-12. Added: trunk/treebase-core/db/cleaning/2010-03-12_stepmatrixelement_seq_priveleges/stepmatrixelement_seq_priveleges.sql =================================================================== --- trunk/treebase-core/db/cleaning/2010-03-12_stepmatrixelement_seq_priveleges/stepmatrixelement_seq_priveleges.sql (rev 0) +++ trunk/treebase-core/db/cleaning/2010-03-12_stepmatrixelement_seq_priveleges/stepmatrixelement_seq_priveleges.sql 2010-03-16 20:03:30 UTC (rev 612) @@ -0,0 +1,5 @@ +BEGIN transaction; +select pg_owner('postgres', 'treebase_owner', 'stepmatrixelement_id_sequence', 'public'); +select pg_grant('treebase_owner', 'ALL', 'stepmatrixelement_id_sequence', 'public'); +select pg_grant('treebase_app', 'ALL', 'stepmatrixelement_id_sequence', 'public'); +END transaction; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |