-- 1. Create a test view
-- ------------------
SQL> show user
USER est "ELRDM"
SQL> CREATE OR REPLACE VIEW ELRDM.v_ae as (
2 select T2.LOGINBO, T1.*
3 from ELRDM.AXE_SMARCHE_ML
4 T1,SECUBO.USER_LANGUE T2
5 where T1.CODLNG = T2.CODLNG
6 and rownum <2
7 );
Vue crÚÚe.
-- 2. grants on tables to SELECTBO
-- ------------------------------
SQL> grant select on SECUBO.USER_LANGUE to SELECTBO WITH GRANT OPTION;
Autorisation de privilÞges (GRANT) acceptÚe.
SQL> grant select on ELRDM.AXE_SMARCHE_ML to SELECTBO with grant option;
Autorisation de privilÞges (GRANT) acceptÚe.
SQL> grant select on ELRDM.V_AE to SELECTBO with grant option;
Autorisation de privilÞges (GRANT) acceptÚe.
-- 3. connect with user SELECTBO an try to select view
-- ---------------------------------------------------
SQL> conn SELECTBO/bobo@dmpr
ConnectÚ.
SQL> select * from ELRDM.v_ae;
select * from ELRDM.v_ae
*
ERREUR Ó la ligne 1 :
ORA-01031: privilÞges insuffisants
-- but the select from tables works
-----------------------------------
select T2.LOGINBO, T1.*
from ELRDM.AXE_SMARCHE_ML
T1,SECUBO.USER_LANGUE T2
where T1.CODLNG = T2.CODLNG
and rownum <2;
Partager