Stored Procedure Privileges Problems

From: Steve B <steve.bright_at_capgemini.co.uk>
Date: Mon, 18 Oct 1999 11:24:24 +0100
Message-ID: <7uesgr$4e5$1@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:24:24 CDT