Edit Study Permissions by database to all existing after implementing security option

[Jonathan Galan]

Hello,

I installed Study Permissions by Role Access WADO and it is working fine.

I need help to creat grant access by database to existing studies, becuase the manually by web interface is a very slow option and the server has 56000 more studies.

I am searching the database script to create access control by role and actions.

I have this Query, to export the Study_iuid by day:

SELECT 

study.study_iuid

FROM 

public.study

WHERE 

study.study_datetime >= '2014-07-15' AND 

study.study_datetime < '2014-07-16';

I need the SQL sentence for use this list of iuids, to create the access permissions on table study_permission

Thanks,

[Ralf Hoffmann]

SHOW INSERT Select * FROM study_permission WHERE study_iuid = 'xyz';

Take the INSERT statement and modify.

[Jonathan Galan]

No working...

> --
> You received this message because you are subscribed to the Google Groups
> "dcm4che" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dcm4che+u...@googlegroups.com.
> To post to this group, send email to dcm...@googlegroups.com.
> Visit this group at http://groups.google.com/group/dcm4che.
> For more options, visit https://groups.google.com/d/optout.
>


--
*
Jonathan Galán*
Cel. 3002669532