took away the DBA role from the schema owner. So the schema owner is
still maintaing all its permissions outside of the dba role.
The thing is that schema owner still has access to the packages,
otherwise Oracle with throw a proceudre not found type error.
So when everything breaks we reapply dba roles, but that doesnt fix
the problem. The packages then need to be recompiled.
-Adam
----- Original Message -----
From: Thomas Chiverton <[EMAIL PROTECTED]>
Date: Fri, 18 Jun 2004 10:46:49 +0100
Subject: Re: Oracle - Incorrect Number of Arguments or Type
To: CF-Talk <[EMAIL PROTECTED]>
On Thursday 17 Jun 2004 21:21 pm, Adrocknaphobia wrote:
> After performing a security lockdown on the Oracle server, namely
> removing DBA from the role which access the package, CF cannot call
> store procedures which return a result set.
What roles/permissions does that leave the CF user with ?
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
