You need to give a user read-only access (e.g. for iAvenue). You have reviewed Creating Read-Only Accounts article, and you would like to know if it is possible to apply the rule to multiple tables at once on the User Admin, rather than to apply the rules on the tables individually on the Schema Wizard.
It is currently not possible to apply a rule to multiple tables at once, in order to give a user read-only access across these tables. The enhancement request regarding this feature has been submitted to our internal New Feature Database for the consideration of our Development Team.