tjones9034
Programmer
Hi all,
I have a sequence on a column which gets populated whenever a any user inserts a new record. Now we would like to restrict the sequence population only to certain users and allow superior users to insert their own values in the field via Form rather than the sequence. Is there any way to disable the sequence only if these users sign in to the application?
Right now we have SELECT Site_Seq.NEXTVAL
INTO :Site.Site_ID
FROM DUAL;
There is a parameter created to check for permissions to this application....example: IF
arameter.P_Level_Precedence >= 60
The levels are from 10 - 70. We want to be able to allow 60 and above to insert values rather than using the sequence. Thanks.
I have a sequence on a column which gets populated whenever a any user inserts a new record. Now we would like to restrict the sequence population only to certain users and allow superior users to insert their own values in the field via Form rather than the sequence. Is there any way to disable the sequence only if these users sign in to the application?
Right now we have SELECT Site_Seq.NEXTVAL
INTO :Site.Site_ID
FROM DUAL;
There is a parameter created to check for permissions to this application....example: IF
arameter.P_Level_Precedence >= 60The levels are from 10 - 70. We want to be able to allow 60 and above to insert values rather than using the sequence. Thanks.
