Skip to content

Instantly share code, notes, and snippets.

@rherrick

rherrick/makeUserAdmin.sql

Created September 18, 2014 14:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rherrick/7180ef23f6702495a726 to your computer and use it in GitHub Desktop.
Save rherrick/7180ef23f6702495a726 to your computer and use it in GitHub Desktop.
Download ZIP
Makes an XNAT user an admin. This requires the user to log out and back in again.
Raw
makeUserAdmin.sql
insert into xdat_r_xdat_role_type_assign_xdat_user (xdat_user_xdat_user_id,xdat_role_type_role_name) values ((select xdat_user_id from xdat_user where login = '$USER$'),'Administrator');
delete from xs_item_cache where contents like '%$USER$%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment