My Oracle Support Banner

LSH DB Users are Unable to View Package Body from Their Individual DB Schema in SQL Developer (Doc ID 2938947.1)

Last updated on MARCH 31, 2023

Applies to:

Oracle Life Sciences Data Hub - Version 3.1.1.3 and later
Information in this document applies to any platform.

Symptoms

On Oracle Health Sciences Data Management Workbench (DMW) 3.1.1.3 version,
a new created LSH DB user is unable to view Package Body from individual DB schema in SQL Developer.

STEPS
-------
The issue can be reproduced with the following steps:
1. Login to SQL Developer with an LSH DB user.
2. Expand Packages from a DB schema associated with a Work Area created by the user.
3. Select the Package Body.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.