Re: Stored Procedure Privileges Problems

A note further :

The only other change that has been made recently is a small change to a table ( increasing the size of a varchar2 column.. )

Could this possibly have a knock on effect ... because it seems that the procedures that are losing the privileges are those which reference the newly altered table....my experience tells me that this should not be the case...but its the only other thing that could possibly have altered the database

Cheers

Steve Bright

steve.bright_at_capgemini.co.uk

Steve B <steve.bright_at_capgemini.co.uk> wrote in message news:7uesgr$4e5$1_at_taliesin.netcom.net.uk...
> Oracle 8.1.5 on NT4.....
>
> We're experiencing problems where users seem to be losing execute
privileges
> for our stored procedures.....The execeure privilege for each procedure
has
> been granted to a role, which all users are assigned to...this works
> fine...BUT every now and again the user seems to lose the privilege to
> execute the procedures...it requires the DBA to recreate the execute
> privileges...it then works fine again...
>
> Whenever we alter a procedure we use the CREATE OR REPLACE proc1 AS
> statement, so the procedures should still be accessable by the users
>
> Has anyone else experienced these problems....or can anyone suggest
anything
> ?????
>
> --
> Cheers
>
> Steve Bright
>
> steve.bright_at_capgemini.co.uk
>
>
>
Received on Mon Oct 18 1999 - 05:30:22 CDT