The same by-law that allows for the installation of the CCTV should establish who can view the footage and under what circumstances.
A sensible suggestion might be any strata committee officer, the strata manager/building manager, the police or any lot owner subject to the written approval of the strata committee and at their own expense.
Note I have excluded ordinary strata committee members – that would be a point for discussion.