Proxy user and privileges

Hi Everyone

We are trying to create a proxy user that should only be able to create trigger on the APP_OWNER tables

The database is 11.2.0.4

Here is what we did

SQL> create role test_role;

Role created.

SQL> grant create trigger,create session to test_role;

Grant succeeded.

SQL> create user test_user identified by test;

User created

SQL> grant test_role to test_user;

Grant succeeded.

SQL> grant test_role to app_owner;

Grant succeeded.

SQL> alter user app_owner grant connect through test_user with role test_role;

User altered.

connect test_user[app_owner]

Enter password: