Mercurial > hg > LGDataverses

diff scripts/search/dbperms @ 10:a50cf11e5178

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Rewrite LGDataverse completely upgrading to dataverse4.0
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Tue, 08 Sep 2015 17:00:21 +0200
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/scripts/search/dbperms	Tue Sep 08 17:00:21 2015 +0200
@@ -0,0 +1,9 @@
+#!/bin/sh
+~/.homebrew/bin/psql -c "
+select dv.id as dvObject, au.id as user
+from dvobject dv, roleassignment ra, authenticateduser au
+where 1=1
+and dv.id = $1
+and dv.id = ra.definitionpoint_id
+and  '@'|| au.useridentifier = ra.assigneeidentifier; 
+" dataverse_db