Re: SQL in Oracle

From: <rtproffitt_at_my-deja.com>
Date: Thu, 07 Oct 1999 15:39:11 GMT
Message-ID: <7tieqt$rds$1@nnrp1.deja.com>

Regarding sequences,

The user must have the rights to select from the named sequence.

Also, if the sequence is being called inside a stored function or procedure, remember that the procedure or function acts on the behalf of the owner of the procedure or function... in which case you would need execute rights on the proc/func. Now, we discovered that it is NOT ENOUGH for the developer/owner to have execute rights on the sequence used inside the proc/func granted by ROLE... it turns out that they must be EXPLICITLY granted to the owner of the stored proc/func.... Otherwise, the sequence would not work properly when called through procedure executed by the user... EVEN THOUGH, logically, it seemed that all the rights (by ROLES) had been granted properly.

Robert Proffitt
Beckman Coulter
Brea, CA

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 07 1999 - 10:39:11 CDT