SELECT DISTINCT 
       a.user_name
     , b.full_name
     , c.responsibility_name
     , to_char(d.start_time, 'DD-MON-YYYY HH24:MI:SS')
     , to_char(d.end_time, 'DD-MON-YYYY HH24:MI:SS')
     , f.name
FROM   fnd_user a
     , per_people_v7 b
     , fnd_responsibility_tl c
     , fnd_login_responsibilities d
     , fnd_logins e
     , v$database f
WHERE 
b.person_id (+) = a.employee_id
AND a.user_id = e.user_id
AND e.login_id = d.login_id
AND d.responsibility_id = c.responsibility_id
AND user_name ='valeur récupérer du user'
AND d.end_time is null

SELECT DISTINCT
       a.user_name
     , b.full_name
     , c.responsibility_name
     , to_char(d.start_time, 'DD-MON-YYYY HH24:MI:SS') //Je connais pas to_char
     , to_char(d.end_time, 'DD-MON-YYYY HH24:MI:SS')
     , f.name
FROM   fnd_user AS a
     , per_people_v7 AS b
     , fnd_responsibility_tl AS c
     , fnd_login_responsibilities AS d
     , fnd_logins AS e
     , v$database AS f
WHERE
b.person_id (+) = a.employee_id //C'est quoi le (+) ?
AND a.user_id = e.user_id
AND e.login_id = d.login_id
AND d.responsibility_id = c.responsibility_id
AND user_name ='valeur récupérer du user'
AND d.end_time is null

$sql = "SELECT... etc... ";

ma requete marche bien sous TOAD (oracle)!!

table or view does not exist

Toutes les tables que j'utilise existe et ma requete marche bien sous TOAD (oracle)!

$sql1 = 
"SELECT DISTINCT a.user_name FROM fnd_user a UNION
 SELECT DISTINCT c.responsibility_name FROM fnd_responsibility_tl c
 WHERE user_name ='ACHEVALIER'";
$sql2 = 
"SELECT DISTINCT a.user_name FROM fnd_user a 
 WHERE user_name ='ACHEVALIER'";
$sql3 = 
"SELECT DISTINCT c.responsibility_name FROM fnd_responsibility_tl c";

Change les droits de l'utilisateurs et ajoute CREATE_VIEW