search

sfa-siard / siard-suite

Other
6 stars 0 forks source link

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

Closed JacCGeo closed 2 months ago

JacCGeo commented 2 months ago

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!

JacCGeo commented 2 months ago

Steps to reproduce:

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

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!