...
Code Block |
---|
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.
- Granted Roles:
- Connect
- System Privileges:
- Advisor
- Alter session
- Create Credential
- Create Database Link
- Create Job
- Create Procedure
- Create Public Synonym
- Create Sequence
- Create Session
- Create Synonym
- Create Table
- Create Trigger
- Create Type
- Create View
- Create Any Procedure
- Debug Connect Session
- Drop Public Synonym
- Select Any Dictionary
- Select Any Table
- Quotas
- LABWARE
- LABWAREIDX
- USERS | 31457280 | K
2. Run DDL to create project tables, sequences, and triggers
...