When ownership is transferred, the previous owner (in this case, the 'DATA ENGINEER role) loses the 'OWNERSHIP' privilege. Any other privileges previously granted to the role remain unless explicitly revoked. The ownership transfer itself does not automatically revoke other privileges. The ownership is implicitly revoked. But all other grants (USAGE etc) will remain.