Product: ChemBioOffice Enterprise
Why can't I add a new user to cs_security? I get an error that says the user code is already taken.
When adding a new user through the ChemOffice Webserver interface, a user may receive the following error:
User code is already taken by another user
This indicates that the Oracle sequence used to assign user ids is out of sequence with respect to the users in the people table. This typically occurs when users are directly inserted into the people table without using the cs_security interface.
The following PL/SQL block will realign the sequence:
Connect
cs_security/oracle@;
DECLARE
I PLS_INTEGER;
J PLS_INTEGER;
C PLS_INTEGER;
BEGIN
select max(person_id) into C from cs_security.people;
FOR I IN 1..C LOOP
SELECT cs_security.people_Seq.NEXTVAL INTO J FROM
DUAL;
END LOOP;
END;
Run the above in Oracle SQL Plus Worksheet.
Comments
0 comments
Article is closed for comments.