= Cheatsheets

[[JDBCAuthOptions]]
== JDBCAuthOptions

++++
 Options configuring JDBC authentication.
++++
'''

[cols=">25%,25%,50%"]
[frame="topbot"]
|===
^|Name | Type ^| Description
|[[authenticationQuery]]`@authenticationQuery`|`String`|+++
Set the authentication query to use. Use this if you want to override the default authentication query.
+++
|[[config]]`@config`|`Json object`|+++
The configuration of the JDBC client: refer to the Vert.x JDBC Client configuration.
+++
|[[datasourceName]]`@datasourceName`|`String`|+++
Set the data source name to use, only use in shared mode.
+++
|[[permissionsQuery]]`@permissionsQuery`|`String`|+++
Set the permissions query to use. Use this if you want to override the default permissions query.
+++
|[[rolesPrefix]]`@rolesPrefix`|`String`|+++
Set the role prefix to distinguish from permissions when checking for isPermitted requests.
+++
|[[rolesQuery]]`@rolesQuery`|`String`|+++
Set the roles query to use. Use this if you want to override the default roles query.
+++
|[[shared]]`@shared`|`Boolean`|+++
Set whether the JDBC client is shared or non shared.
+++
|===

[[JDBCAuthenticationOptions]]
== JDBCAuthenticationOptions

++++
 Options configuring JDBC authentication.
++++
'''

[cols=">25%,25%,50%"]
[frame="topbot"]
|===
^|Name | Type ^| Description
|[[authenticationQuery]]`@authenticationQuery`|`String`|+++
Set the authentication query to use. Use this if you want to override the
 default authentication query.
+++
|===

[[JDBCAuthorizationOptions]]
== JDBCAuthorizationOptions

++++
 Options configuring JDBC authentication.
++++
'''

[cols=">25%,25%,50%"]
[frame="topbot"]
|===
^|Name | Type ^| Description
|[[permissionsQuery]]`@permissionsQuery`|`String`|+++
Set the permissions query to use. Use this if you want to override the
 default permissions query.
+++
|[[rolesQuery]]`@rolesQuery`|`String`|+++
Set the roles query to use. Use this if you want to override the default
 roles query.
+++
|===

