To delete a row from the table, you must have DBA privileges, ownership of the table, or DELETE permission of the table.

A user mapped to a super-tenant can view data for all the tenants only if the user has the required permissions on the tables referenced in the statement.