Roles Are Disabled at Package Compilation Time
When granting permissions through roles, it is important to know that rolesare disabled while packages are compiled. For example, consider two schemas: User_A and User_B. Let’s create Role_A: CREATE ROLE