provider-sql
provider-sql copied to clipboard
crossplane-contrib
An SQL provider for @crossplane
### What problem are you facing? Whenever you need to inject queries into a different cluster/database engine, you must create a new provider instance. ### How could Crossplane help solve...
We would like to create a read-only role, is there any way to do this? We can create a read-write user by granting create (which results in a `grant create...
### What happened? Following with the changes introduced in: - https://github.com/crossplane-contrib/provider-sql/pull/148 - https://github.com/crossplane-contrib/provider-sql/pull/149 creating a MySQLGrant (`mysql.sql.crossplane.io/v1alpha1`) that includes `WITH GRANT OPTION` works, but deleting the MySQLGrant resource results in...
### Description of your changes Fixes #127 I have: - [x] Read and followed Crossplane's [contribution process]. - [x] Run `make reviewable` to ensure this PR is ready for review....
### What problem are you facing? Why every time a `CREATE`, `ALTER` or `DROP USER` statement is executed, `FLUSH PRIVILEGES` is called after? It's also present after `GRANT` and `REVOKE`...
Signed-off-by: Jens Hausherr Caveat: At the moment this PR is primarily for discussing the approach. Test coverage et al. are not added yet. ### Description of your changes After fixing...
### What happened? When creating or updating a grant sql provider always try to grant it for ``@`%`, instead of ``@``. Which results in an `Error 1410: You are not...
### Description of your changes Fixes [#125](https://github.com/crossplane-contrib/provider-sql/issues/125) I have: - [x] Read and followed Crossplane's [contribution process]. - [x] Run `make reviewable` to ensure this PR is ready for review....
### What problem are you facing? I would like to create mysql (v8.0+) users identified by ldap ([authentication_ldap_simple](https://dev.mysql.com/doc/refman/8.0/en/ldap-pluggable-authentication.html)) instead of by password ([mysql_native_password](https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html)). Also it would be great if authenticating...