- 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
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
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
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
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:
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
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
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