Copy group permission on fields

[Guest_imported]

Hello everybody,

I work with ARS 4.02
I've a group1 (ID=10007) and I want to give exactly the same right to a group2 (ID=10066)
I've tried to do this query

"
INSERT INTO FIELD_PERMISSIONS
(SCHEMAID, FIELDID, GROUPID, PERMISSION)
SELECT
SCHEMAID, FIELDID, 10066, PERMISSION
FROM FIELD_PERMISSIONS
WHERE GROUPID=10007
)

But the changes don't appears to the administrators screen.

Does somebody know a method to do this ?

Thanks for your help.

Raphaël AMIRI

 

[RmdyJoe]

Why dont you just use the USer tool and enter into the group form?

 

[chrishaw]

I think you have your group ID's backwards in the select statement part. You don't want to select where GROUPID=10007, you want to select where GROUPID=10066.