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

Oracle Error Message

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

Reason for the Error

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

Solution

Grant the privileges required to the user directly.