provider-sql icon indicating copy to clipboard operation
provider-sql copied to clipboard

Add Azure AD authentication support for mssql

Open Mikel-Landa opened this issue 2 years ago • 6 comments

Description of your changes

Fixes #165

I have:

  • [x] Read and followed Crossplane's contribution process.
  • [x] Run make reviewable to ensure this PR is ready for review.

How has this code been tested

Created a local cluster and connected to an existing database. Tested a creation of a database, user and grant and then connected through ad to the database with the provisioned user

NAME                                             READY   SYNCED   AGE
database.mssql.sql.crossplane.io/example-db-ad   True    True     96m

NAME                                          READY   SYNCED   AGE   ROLE          DATABASE        PERMISSIONS
grant.mssql.sql.crossplane.io/example-grant   True    True     7s    ***@***.com   example-db-ad   ["CONNECT","CREATE TABLE","INSERT","SELECT"]

NAME                                           READY   SYNCED   AGE
user.mssql.sql.crossplane.io/example-user-ad   True    True     93s

Mikel-Landa avatar Dec 04 '23 16:12 Mikel-Landa

Would you mind rebasing?

Duologic avatar Jun 10 '24 08:06 Duologic

@Duologic i've rebased it

Mikel-Landa avatar Jun 12 '24 08:06 Mikel-Landa