Automatically Setting All Common Locations for All Audiences

You can run SQl queries in DbEdit.

Open DbEdit and click File > New. In the New dialog box, choose SQL Query.
  1. Type the following SQL query: 
    declare @locid int declare locid cursor for select locid
from locations open locid
fetch next from locid into @locid while @@fetch_status = 0
begin
insert into InfoAudienceTargets values ('LOC',@locid,'Audiences>FX') 
insert into InfoAudienceTargets values ('LOC',@locid,'Audiences>PASS') 
fetch next from locid into @locid
end
close locid deallocate locid
  2. In the Insert statement, edit the Audience key to match what you had set in the Audience.security file.
  3. On the main toolbar, click the Generate button: Generate button in DbEdit screen