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

"Only one view with the same name allowed per schema!" when archiving Oracle Database #109

Closed
JacCGeo opened this issue Sep 12, 2024 · 2 comments
Labels
bug Something isn't working question Further information is requested

Comments

@JacCGeo
Copy link

JacCGeo commented Sep 12, 2024

I am using SIARD Suite 2.2.147 to archive an Oracle database. I keep getting the error message: "Only one view with the same name allowed per schema!" even though I've restricted the database user's permissions as much as possible by giving him only one simple table, but the error persists.

I'm not sure if I'm missing something in the database setup or if there's another reason for this error.

Any advice on how to fix this would be greatly appreciated!

Environment:

SIARD Suite version: 2.2.147
Database: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
Thanks!

@mburri mburri added bug Something isn't working question Further information is requested labels Sep 13, 2024
@JacCGeo
Copy link
Author

JacCGeo commented Sep 16, 2024

Steps to reproduce:

  1. CREATE USER SIARD IDENTIFIED BY "XXXXXXXXX"
  2. GRANT CREATE SESSION TO SIARD
  3. GRANT SELECT ON VIEW TO SIARD

@JacCGeo
Copy link
Author

JacCGeo commented Sep 19, 2024

The issue was caused by a public grant in our database. The old version of SIARDASuite, which came from SIARDGUI, also provided logs directly in the UI, which is not available in the new tool. I would really appreciate it if this feature could be included again in a future version. Thank you!

@JacCGeo JacCGeo closed this as completed Sep 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants