Question
I want the Scriptura Servers to use an Oracle database. Which roles and authorization does the user need?
Answer
The user that will be connecting to the database, needs the following access :
CONNECT access to the database
CREATE, DROP table (for Scriptura upgrades)
SELECT, INSERT, UPDATE, DELETE table
CREATE, DROP sequence (for Scriptura upgrades)
SELECT sequence