MgOtIR,

Возможно HR_SECURE_USER - это application secure role
Её не на грантовать пользователю, процедура сама проверит кто вы и какие привилегии вам нужны.

http://docs.oracle.com/database/121/DBSEG/app_devs.htm#DBSEG146 Create the security application role as follows:

1.

This statement indicates the following:

-The role hr_admin to be created is a secure application role.

-The role can only be enabled by modules defined inside the PL/SQL procedure sec_mgr.hr_admin_role_check. At this stage, this procedure does not need to exist;
"Step 2: Create a PL/SQL Package to Define the Access Policy for the Application" explains how to create the package or procedure.

2. Grant the security application role the privileges you would normally associate with this role.
For example, to grant the hr_admin role SELECT, INSERT, UPDATE, and DELETE privileges on the HR.EMPLOYEES table, you enter the following statement:


Do not grant the role directly to the user. The PL/SQL procedure or package does that for you, assuming the user passes its security policies.