view scripts/search/dbperms @ 12:c2e2d794847f

new: add config.properties file for gazetteer
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Wed, 30 Sep 2015 13:43:54 +0200
parents a50cf11e5178
children
line wrap: on
line source

#!/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