Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
gillianh1 opened this issue Sep 13, 2022 · 2 comments

Comments

@gillianh1
Copy link

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.

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

@gillianh1
Copy link
Author

This may have been opened in the wrong place? As this is an issue with Desktop DBPTK
I have also opened this issue #529

@hmiguim
Copy link
Member

hmiguim commented Sep 20, 2022

Close duplicated from #529

@hmiguim hmiguim closed this as completed Sep 20, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants