T107-2022 New installation of BIOVIA Notebook 2022 with a backend Oracle database, the Lookup functionality not enabled.

T107-2022 New installation of BIOVIA Notebook 2022 with a backend Oracle database, the Lookup functionality not enabled.

Superuser doesn’t have the admin privilege, ELNADMINCREATELOOKUPADMIN. This is required to grant other users the privilege, ELNADMINCREATELOOKUP for them to configure lookup sections via the new admin functionality.

November 2021

Program

BIOVIA Notebook 2022

Operating System

Microsoft Windows Server (64 bit), 2016 and 2019

Background

Only applies to new installation of Notebook 2022 with a backend oracle instance.

A new functionality to configure lookup sections was introduced in Notebook 2022. Users with

ELNADMINCREATELOOKUP are able to configure new lookup section using the new admin functionality.

Only a user with ELNADMINCREATELOOKUPADMIN can grant the above privilege to a user.

However, this privilege was not granted to superuser, therefore, none of the users can perform this admin functionality.

Workaround

Run the SQL statement below, as Oracle user ELN, after the Notebook database has been installed:

insert into DIRPRIVILEGE (PKEY, PRIVID)

VALUES

((select pkey from user_details where Upper(userid)=Upper('Superuser')), (select privid from privilege where Upper(name)=Upper('ELNADMINCREATELOOKUPADMIN')));

commit;

BIOVIA Support

If you have any questions, please contact BIOVIA Support.