...

create user geodp### identified by "stored-secret";
alter user geodp###
default tablespace geodesc
temporary tablespace temp
quota unlimited on geodesc
quota unlimited on geodescidx
;

grant create session to geodp###;
grant create sequence to geodp###;
grant create table to geodp###;
grant create trigger to geodp###;

Historical Note

During initial development, these roles, privileges, and storage configurations were applied.

• Note that the above are sufficient for operational use.
• Note that storage is moved to dedicated tablespaces (geodesc, geodescidx) for operational use.

1. Granted Roles:
   1. Connect
2. System Privileges:
   1. Advisor
   2. Alter session
   3. Create Credential
   4. Create Database Link
   5. Create Job
   6. Create Procedure
   7. Create Public Synonym
   8. Create Sequence
   9. Create Session
   10. Create Synonym
   11. Create Table
   12. Create Trigger
   13. Create Type
   14. Create View
   15. Create Any Procedure
   16. Debug Connect Session
   17. Drop Public Synonym
   18. Select Any Dictionary
   19. Select Any Table
3. Quotas
   1. LABWARE
   2. LABWAREIDX
   3. USERS |  31457280 | K

2. Run DDL to create project tables, sequences, and triggers

...