YAML
####################################################################################################
# Example YAML for Tot Plugin Jdbc Oracle #
# #
# This file has all the technical properties that can be edited for the client. #
# These properties have a default value in the application, #
# so there is no necessity to configure them. #
# Only configure these properties if they are going to be different to the value of this file, #
# this will make your files more clean and readable. #
####################################################################################################
#########################
### Server properties ###
#########################
server:
port: 15013
#############################
### Tot Plugin properties ###
#############################
totplugin:
server:
# Tot server URL. It is a list because Tot can have more than one instance running.
urls:
- https://tot1server.anjanadata.local:15000/tot/
################################
## Oracle connection properties
## url: where oracle service is running
## user: user to log in
## password: password
## path-separator: character to be used on path
## query-separator: character to be used on query
## sampleRows: number of rows in sample
## obfuscation-string: string to replace information when it is obfuscated
################################
connection:
- name: dev # name of the instance connection
technology:
url: <url>
user: <user>
password: <password>
path-separator: "/"
query-separator: "."
sampleRows: 15
obfuscation-string: "*****"
#############################
### Query pattern ###
#############################
## createRole: create role query
## existRole: check if exist role
## grantSelect: grant select permission to role on table
## deleteRole: delete role query
## revokeSelect: revoke select permission to role on table
## identifiedGlobally: link role in oracle with ad group
sql:
query-pattern:
createRole: "CREATE ROLE {0}"
existRole: "SELECT * FROM dba_roles WHERE ROLE = {0}"
grantSelect: "GRANT READ ON {0} TO {1}"
deleteRole: "DROP ROLE {0}"
revokeSelect: "REVOKE READ ON {0} FROM {1}"
identifiedGlobally: " IDENTIFIED GLOBALLY AS {1}"
# To define the different ARIs of plugin functionalities
aris:
- ari: "anja:totplugin:extract:/jdbc/oracle/devQA/"
- ari: "anja:totplugin:sample:/jdbc/oracle/devQA/"
- ari: "anja:totplugin:create:/jdbc/oracle/devQA/"
- ari: "anja:totplugin:edit:/jdbc/oracle/devQA/"
- ari: "anja:totplugin:im:/jdbc/oracle/devQA/"
imAri: "anja:totplugin:im:/ldap/ldap/ldap/"
# Example of the hierarchy established for group names in the external identity manager
globalGroupName: cn={0},ou=groups,dc=anjanadata,dc=org
# The same variable globalGroupName is used for IAM oracle cloud
# globalGroupName: IAM_GROUP_NAME={0}
# Group prefix of dsa, only use if not config imAri
groupPrefix: Dsa_
########################
## Logs properties ###
########################
logging:
pattern:
# Pattern to convert logs in the convenient format for the client
console: "%clr(%d{yyyy-MM-dd HH:mm:ss.SSS}){faint} [TOT-PLUGIN-JDBC-ORACLE] %clr(${LOG_LEVEL_PATTERN:%5p}) %clr(${PID:- }){magenta} %clr(---){faint} %clr([%15.15t]){faint} %clr(%-40.40logger{39}){cyan} %clr(:){faint} %m%n${LOG_EXCEPTION_CONVERSION_WORD:%wEx}"
# Mark the level of log to show for every package. ERROR > WARN > INFO > DEBUG > TRACE
level:
# The main log level this is the base fot all logs
root: info
# Every package of code can be marked with a different log level, every package of code printed on log is selectable to have a record here and mark a log level
com.anjana: DEBUG
################################
## Hecate(Eureka) properties ###
################################
eureka:
client:
serviceUrl:
# Url where Tot is listening
defaultZone: http://totserver:15000/tot/eureka