[SQL] Setting "subject to acl" for multiple products

Hi guys,

in my store i have several product (about 500 items)

for some of them i need to set Acl for specific customer Role

i managed by SQL to insert rows related to products i need to restrict inside "dbo.AclRecord"

but when i was back on admin panel i couldn't see Acl and the checkbox "subject to acl" is disabled.

I'm totally new in nopcommerce and a bit in SQL too, but i think that simply adding data in relative table
isn't enough,

Is there also some kind of function to invoke or some other field in other table to set?

Thank you in advance for noob question.

Have a nice day.

Ops..
Just found "subjectToAcl" inside Product table.

I'll try an update on this.

Sorry for useless question


[UPDATE]

I confirm that works!!

Could you give example of SQL please?

I am working my way thru the same issue.

I am using FoxNetSoft import plugin for Tier Pricing, but also need to show certain products ONLY to certain customers.

Hi

I am trying to setup ACL for products via SQL.

Does anyone have a SQL script that can do this?

Thanks in advance
David