ORA-01933: cannot create a stored object using privileges from a role

ORA-01933: cannot create a stored object using privileges from a role


Cause:


An attempt was made to create a stored object using privileges from a role. Stored objects cannot use privileges from roles.



Action:


Grant the privileges required to the user directly.