Re: SET ROLE and stored procedures

kuismin_at_ntc01.tele.nokia.fi wrote:

: Hi!
: Is it possible to use SET ROLE command in a stored
: procedure.
 

: I have a following procedure, which gives an error message
: from the SET ROLE command.
 

: create or replace procedure s_role is
: vrole a.priv.user_role%TYPE;

:    	begin


: 	   select user_role into vrole 


: 	   from a.priv where orauser=user;

: 	   set role vrole;

: 	end;

 


: 	Our attention is to check user role from a application


: 	priviledge table a.priv and then enable that role.

: 	But this is not working!   

: 	We have lost our PL/SQL User Guide for Oracle7 so I can't

: 	check this out.

 


: 	-Mikko Kuismin



You can use dbms_session.set_role (vrole) 

Teijo Doornkamp (doornkampt_at_vertis.nl) Received on Fri Nov 25 1994 - 01:39:11 CET