topic Re: edit 'h2.data.sql' in Alfresco Archive

edit 'h2.data.sql'

arne_engels — Mon, 12 Jul 2010 11:48:16 GMT

Hello!I tried to add a new user to the existing demo-users and edited the 'h2.data.sql'-file in the demo folder:insert into ACT_ID_USER values ('NewUser', 1, 'New', 'User', 'new@localhost', 'new');insert into ACT_ID_MEMBERSHIP values ('NewUser', 'user');insert into ACT_ID_MEMBERSHIP values (NewUser'

Re: edit 'h2.data.sql'

jbarrez — Mon, 12 Jul 2010 14:48:44 GMT

Your user needs to be part of this group:

insert into ACT_ID_GROUP values ('user', 1, 'User', 'security-role');

Re: edit 'h2.data.sql'

arne_engels — Mon, 12 Jul 2010 15:32:43 GMT

Thanks for your answer, but i'm not sure if i got you right:
with insert into ACT_ID_MEMBERSHIP values ('NewUser', 'user'); the specified user should be already part of the existing 'user'-group, right ? (with 'insert into ACT_ID_GROUP values ('user', 1, 'User', 'security-role');' at the top of the file)
The 'New User' is listed as 'user' in the 'ACT_ID_MEMBERSHIP'-table.

I'm running the alpha3 with WinXP