You can do this with section Access, something like this
//Table with users, NTNAME are their OS login ID's
//In ACCESGROUP you assign some value e.g. YES/NO to each user who can see sheet2
Load NTNAME, ACCESS, ACCESSGROUP
//link to your data
Load * inline [ACCESGROUP
Then in the layout properties of your textbox/button put ACCESSGROUP='YES' in the conditional show
Please find the attached application.
User Access Info
ACCESS USERID PASSWORD GROUP ADMIN admin admin * USER User1 User1 GROUP1 USER User2 User2 GROUP2
Sheet access Info
GROUP Report1 Report2 GROUP1 1 0 GROUP2 0 1
Hidden Script pwd : 123
User1 has accessto Only Report1
User2 has accessto Only Report2
Admin has access to all reports.