Re: Problem with roles

From: wweiss <wayne.weiss_at_ssa.gov>
Date: Fri, 20 Aug 1999 11:44:16 -0400
Message-ID: <7pjt6j$qsn$1@s00dacf.ssa.gov>

Get the connected user from the pseudo column user then query dba_role_privs.

create or replace procedure wwtst
as
v_user dba_users.username%TYPE;
cursor c1 is select granted_role

               from dba_role_privs
               where grantee = v_user;

begin

   select user into v_user from dual; /* get connected user */    dbms_output.put_line('User: '||v_user);

   for c1_rec IN c1 LOOP               /* fetch roles for connected user */
      dbms_output.put_line('Granted_Role:  '||c1_rec.granted_role);

   end loop;
end;

dm_zo_at_my-deja.com wrote in message <7pjfbe$jhe$1_at_nnrp1.deja.com>...
>Hi,
>I have a little problem:
>I need to select in PL/SQL package roles granted
>to the current user.
>But if I use view "user_role_privs" I receive
>roles granted to package creator.
>What can I use instead of "user_role_privs"?
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Fri Aug 20 1999 - 10:44:16 CDT