ORA-01933: cannot create a stored object using privileges from a role
What triggered the Error:
An attempt was made to create a stored object using privileges from a role. Stored objects cannot use privileges from roles.What should we do to fix it:
Grant the privileges required to the user directly.