A user with manage database permissions privilege in database db1 issues the following to allow user app_user to execute DML commands on all user tables and execute any stored procedures and user-defined functions defined in db1:
use db1 grant insert any table to app_user grant select any table to app_user grant update any table to app_user grant truncate any table to app_user grant delete any table to app_user grant identity_insert any table to app_user grant identity_update any table to app_user grant execute any procedure to app_user grant execute any function to app_user
