[ORA-00942] DBA_TAB_PRIVS dans une fonction

bonjour,

est ce que quelqu 'un pourrais me dire pourquoi j'ai toujours l'erreur ORA-00942 : table or view does not exist :

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

CREATE OR REPLACE FUNCTION RLS_TEST (P_TABLE IN VARCHAR2 ) RETURN NUMBER   IS   CURSOR C_TABPRIVS(B_TABLE VARCHAR2 ,B_ROLE VARCHAR2) IS SELECT GRANTEE FROM DBA_TAB_PRIVS WHERE TABLE_NAME = B_TABLE AND GRANTEE = B_ROLE AND PRIVILEGE = 'SELECT';     V_DUMMY NUMBER;   BEGIN OPEN C_TABPRIVS ('TABLE_TEST', 'ROLE_TEST'); FETCH C_TABPRIVS INTO V_DUMMY; IF C_TABPRIVS%FOUND THEN CLOSE C_TABPRIVS; RETURN (1); ---TRUE TROUVE END IF; CLOSE C_TABPRIVS; RETURN (0); END;

---

et pourtant si j'execute le select à part ca me retourne des rangées et ca semble connaitre la view dba_tab_privs.

Code:

---

SELECT GRANTEE FROM DBA_TAB_PRIVS

---

j'utilise oracle 9207.

merci pour votre aide

Pour etre 'vus' depuis une procedure stockee, ton utilisateur doit acquerir les droits sur les objects de maniere directe, sans passer par un role.

Cf le note Metalink Note:168168.1 pour plus d'information.

Citation:

---

Limitations of Privileges and Roles: Stored PL/SQL
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Roles are disabled when stored procedures or packages are executed.

A user executing a procedure or package can perform actions against objects
(select a table, select a view, create a table, create a view, create a trigger).
When the necessary privileges are granted to this user indirectly via a role,
the result is ORA-00942 or ORA-01933 or ORA-01031 and ORA-06512 or PLS-00201 and
ORA-06550.

These actions are successfull when the necessary privileges are granted directly
to the user.

This means that the user executing the procedure or package should be granted
the privileges nequired to perform the actions against objects directly.

A user cannot acquire a privilege via a role if he needs that privilege when
executing a stored procedure or function or package.
If the user issues the same statements in SQL, it works as the user can use the
privileges granted via a role.

---

Ca marche merci pour ta precieuse information.