Re: Can someone please verify this for me?

2003-10-11 Thread Nuno Souto
- Original Message - I haven't tried using these before, but I do notice that your 'create role' syntax appears to be incorrect for this usage. Sorry for the late reply, folks. Rugby World Cup got in the way... :D Yeah, found out what the problem was after all. I assumed that

Can someone please verify this for me?

2003-10-09 Thread Nuno Souto
I have a problem with the new procedure based roles, Secure Application Roles. The following is taken from an example in ASKTOM. Basically, I'm trying to setup a role that is enabled or not by a procedure. The original code from Tom: [EMAIL PROTECTED] l 1 create or replace procedure

Re: Can someone please verify this for me?

2003-10-09 Thread Mladen Gogala
Maybe you should try with DBMS_SESSION.SET_ROLE? On Thu, 2003-10-09 at 11:09, Nuno Souto wrote: I have a problem with the new procedure based roles, Secure Application Roles. The following is taken from an example in ASKTOM. Basically, I'm trying to setup a role that is enabled or not by a

RE: Can someone please verify this for me?

2003-10-09 Thread Igor Neyman
Strange... works fine here (same environment 9.2.0.1 on Win2K server): SQL*Plus: Release 9.2.0.1.0 - Production on Thu Oct 9 13:43:23 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the

RE: Can someone please verify this for me?

2003-10-09 Thread Khedr, Waleed
It worked for me 9.2.0.2 Solaris 2.8 But I'm surprised since I always thought that roles are disabled in stored procs. Even it worked for me but it's still disabled in the stored proc after the execute immediate. Waleed -Original Message- Sent: Thursday, October 09, 2003 11:09 AM To:

Re: Can someone please verify this for me?

2003-10-09 Thread Nuno Souto
Nope. Tried with that one as well, same result. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Maybe you should try with DBMS_SESSION.SET_ROLE? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network

Re: Can someone please verify this for me?

2003-10-09 Thread Jose Luis Delgado
Sure... there you go! SQL create role new_role identified by password; Role created. SQL 1 create or replace procedure turn_on_role 2 authid current_user 3 as 4 begin 5 execute immediate 6 'set role new_role'; 7* end; SQL / Procedure created. SQL set role

Re: Can someone please verify this for me?

2003-10-09 Thread Jared . Still
selected. 13:19:55 dv03 Jared Nuno Souto [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2003 08:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Can someone please verify this for me? I have a problem