Oracle DBA, How To, Error, Cause and Action

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.