a site area unavailable message. Yay!
-Adam
On Fri, 18 Jun 2004 12:29:47 -0400, Adrocknaphobia
<[EMAIL PROTECTED]> wrote:
>
> CF is connecting as the schema owner. Everything worked fine until we
> 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]
