Re: Q: Forms 4.5 and sequence.nextval problem
From: Gary Assa <gsa_at_li.net>
Date: 1997/02/07
Message-ID: <5dfbtl$ipp_at_linet01.li.net>#1/1
Date: 1997/02/07
Message-ID: <5dfbtl$ipp_at_linet01.li.net>#1/1
>> We have a forms 4.5 form and want to use a sequence for an incremental
>> number. The problem we are having is that the sequence is in another
>> users schema. If we try to compile the trigger, it fails with internal
>> error. We create a dummy sequence in our schema and it works fine (which
>> answers the question whether sequences as a general rule cause a problem).
>> In SQL*Plus we can increment the sequence for the other user, but not in
>> forms. What is a workaround???
>
> GRANT SELECT ON seq TO user
> directly instead of through role.
>
This will NOT work. You must create a synonym for the sequence and then
grant select on that synonym.
-- ========================================================= http://www.li.net/~gsa/index.html This is my signature file, not part of this mail message.Received on Fri Feb 07 1997 - 00:00:00 CET