CREATE FORCE VIEW USERBO.USERPROFILE_VIEWSince the view is being created in schema 'USERBO', please check if you have proper grants on Table- 'CLIENT' in schema- 'GENERAL' for 'USERBO'.
|| ' '
upper(client.username) || '-' || client.organization_id,
WHERE ((client.row_id = RESPONSABILITYUSER.user_id))
AND client.status ='ACTIVE'
the strange is that the select extract from the view and execute from user USERBO
works without errors and the two USER (USERBO AND CLIENT) are dba users.
I must grant select on all tables ??
CREATE FORCE VIEW userbo.userprofile_view (row_id, employee, responsability_id, ruolo, e_username, e_password, usertype, user_id) AS SELECT responsabilityuser.row_id, client.surname || ' ' || client.name, responsabilityuser.responsability_id, 'USERWEB', Upper(client.username) || '-' || client.organization_id, client.pwd, client.usertype, client.row_id FROM responsabilityuser, general.client WHERE (( client.row_id = responsabilityuser.user_id )) AND client.status = 'ACTIVE'
GcG-Italia wrote:Since both are already DBA (Which they should probably not be), you don't jeopardize much by granting SELECT ANY TABLE to USERBO.
BUT THE SELECT WORKS FINE
AND ALL 2 USERS ARE DBA !!!
WHAT I CAN DO ??