keeps/dbptk-developer

I can only extract tables from an Oracle database if connect as a user that owns the objects.

gillianh1 opened this issue · 2 comments

gillianh1 commented

Description: I can only extract tables from and Oracle database if connect as a user that owns the objects. I was expecting to be able to connect to a user with read only permissions on objects I want to extract.

Context:
DBPTK Desktop: Installed on Windows 10 PC
Using dbptk-desktop-2.6.0.exe

Steps required to reproduce the bug:

1.I've created a user with select permissions to 6 tables in an Oracle database.
2.When run DBPTK Desktop to create SIARD file and point to this user on the database no tables are extracted to siard file.
3.I've created another user which owns a copy of these 6 objects - in this case when I create a SIARD file the tables are included in the SIARD file.

I was under the impression that we only required an account with read access to objects in order to produce a SIARD file from an oracle database.

Is this not the case? Does the user need to own the objects?

Thanks

hmiguim commented

Hi,

You need those permissions to fetch metadata about the table that is only available to the owner.

gillianh1 commented

Thanks for confirmation. We will need to make sure we extract as the object owner. Or copy to a staging user before extracting.

I had thought DBPTK would have the same requirements as SIARD Suite which requires the setup of a read only account.
https://www.bar.admin.ch/bar/en/home/archiving/tools/siard-suite.html
image

  • 👍1