Closed MikeKutz closed 4 years ago
This is a note to be included in the README.md file
Oracle Cloud Free Tier Autonomous Transaction Processor (ATP).
It is (currently) a 19c EE database with some limitations (and 20GB of free space :) )
As the ADMIN (your DBA account), use a simple 'Hello World' as your template.
'Hello World'
ORA-06598: insufficient INHERIT PRIVILEGES privilege
Unlike normal users, the INHERIT PRIVILEGES was revoked from PUBLIC for the user ADMIN.
As such, Invoker's Rights packages, like tePLSQL, will fail for the user ADMIN. This is a security feature of ATP.
tePLSQL
As a normal user, tePLSQL can run. BUT make sure your templates are referencing the ALL_% dictionary views ( and not DBA_% dictionary views.
the ALL_%
DBA_%
Outside of adjusting the FAQ/README, this won't be fixed.
This is a note to be included in the README.md file
Environment
Oracle Cloud Free Tier Autonomous Transaction Processor (ATP).
It is (currently) a 19c EE database with some limitations (and 20GB of free space :) )
Setup
Test
As the ADMIN (your DBA account), use a simple
'Hello World'as your template.Result
Reason
Unlike normal users, the INHERIT PRIVILEGES was revoked from PUBLIC for the user ADMIN.
As such, Invoker's Rights packages, like
tePLSQL, will fail for the user ADMIN. This is a security feature of ATP.Workaround
As a normal user,
tePLSQLcan run. BUT make sure your templates are referencingthe ALL_%dictionary views ( and notDBA_%dictionary views.Outside of adjusting the FAQ/README, this won't be fixed.