search

gluent / goe

GOE: a simple and flexible way to copy data from an Oracle Database to Google BigQuery.
Apache License 2.0
8 stars 2 forks source link

Remove unnecessary Oracle privilege #133

Closed nj1973 closed 3 months ago

nj1973 commented 3 months ago

In sql/oracle/source/sql/create_offload_privs.sql we have the following grant:

GRANT FLASHBACK ANY TABLE TO &goe_db_app_user.;

This is unnecessary and can be removed.

nj1973 commented 3 months ago

Turns out it is not unnecessary:

select count(*) FROM "GOE_TEST"."KEYWORD_COLS";

  COUNT(*)
----------
         1

select count(*) FROM "GOE_TEST"."KEYWORD_COLS" AS OF SCN 8107663;
select count(*) FROM "GOE_TEST"."KEYWORD_COLS" AS OF SCN 8107663
                                *
ERROR at line 1:
ORA-01031: insufficient privileges
nj1973 commented 3 months ago

Closing.