dbformysql.azure.com/


User


User is a MySQL user

Used by: UserList.

Property Description Type
metav1.TypeMeta
metav1.ObjectMeta
spec UserSpec
Optional
status UserStatus
Optional

UserSpec

Property Description Type
aadUser AADUser contains details for creating an AAD user. AADUserSpec
Optional
azureName The name of the resource in Azure. This is often the same as the name of the resource in Kubernetes but it doesn’t have to be. If not specified, the default is the name of the Kubernetes object. When creating a local user, this will be the name of the user created. When creating an AAD user, this must have a specific format depending on the type of AAD user being created. For managed identity: “my-managed-identity-name” For standard AAD user: “myuser@mydomain.onmicrosoft.com” For AAD group: “my-group” string
Optional
databasePrivileges The database-level roles assigned to the user (keyed by database name). Privileges include the following: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER map[string]string[]
Optional
hostname Hostname is the host the user will connect from. If omitted, the default is to allow connection from any hostname. string
Optional
localUser LocalUser contains details for creating a standard (non-aad) MySQL User LocalUserSpec
Optional
owner The owner of the resource. The owner controls where the resource goes when it is deployed. The owner also controls the resources lifecycle. When the owner is deleted the resource will also be deleted. Owner is expected to be a reference to a dbformysql.azure.com/FlexibleServer resource genruntime.KubernetesOwnerReference
Required
privileges The server-level roles assigned to the user. Privileges include the following: RELOAD, PROCESS, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT, CREATE USER string[]
Optional

UserStatus

Property Description Type
conditions The observed state of the resource conditions.Condition[]
Optional

UserList

Property Description Type
metav1.TypeMeta
metav1.ListMeta
items User[]
Optional

UserSpec

Used by: User.

Property Description Type
aadUser AADUser contains details for creating an AAD user. AADUserSpec
Optional
azureName The name of the resource in Azure. This is often the same as the name of the resource in Kubernetes but it doesn’t have to be. If not specified, the default is the name of the Kubernetes object. When creating a local user, this will be the name of the user created. When creating an AAD user, this must have a specific format depending on the type of AAD user being created. For managed identity: “my-managed-identity-name” For standard AAD user: “myuser@mydomain.onmicrosoft.com” For AAD group: “my-group” string
Optional
databasePrivileges The database-level roles assigned to the user (keyed by database name). Privileges include the following: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER map[string]string[]
Optional
hostname Hostname is the host the user will connect from. If omitted, the default is to allow connection from any hostname. string
Optional
localUser LocalUser contains details for creating a standard (non-aad) MySQL User LocalUserSpec
Optional
owner The owner of the resource. The owner controls where the resource goes when it is deployed. The owner also controls the resources lifecycle. When the owner is deleted the resource will also be deleted. Owner is expected to be a reference to a dbformysql.azure.com/FlexibleServer resource genruntime.KubernetesOwnerReference
Required
privileges The server-level roles assigned to the user. Privileges include the following: RELOAD, PROCESS, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT, CREATE USER string[]
Optional

UserStatus

Used by: User.

Property Description Type
conditions The observed state of the resource conditions.Condition[]
Optional

AADUserSpec

Used by: UserSpec.

Property Description Type
alias Alias is the short name associated with the user. This is required if the AzureName is longer than 32 characters. Note that Alias denotes the name used to manage the SQL user in MySQL, NOT the name used to log in to the SQL server. When logging in to the SQL server and prompted to provider the username, supply the AzureName. string
Optional
serverAdminUsername ServerAdminUsername is the username of the Server administrator. If your server admin was configured with Azure Service Operator, this should match the value of the Administrator’s $.spec.login field. If the administrator is a group, the ServerAdminUsername should be the group name, not the actual username of the identity to log in with. For example if the administrator group is “admin-group” and identity “my-identity” is a member of that group, the ServerAdminUsername should be “admin-group” string
Required

LocalUserSpec

var _ genruntime.ConvertibleSpec = &UserSpec{}
ConvertSpecFrom populates our ConfigurationStore_Spec from the provided source func (userSpec *UserSpec) ConvertSpecFrom(source genruntime.ConvertibleSpec) error { if source == userSpec { return errors.New(“attempted conversion between unrelated implementations of github.com/Azure/azure-service-operator/v2/pkg/genruntime/ConvertibleSpec”) }
return source.ConvertSpecTo(userSpec) }
ConvertSpecTo populates the provided destination from our ConfigurationStore_Spec func (userSpec *UserSpec) ConvertSpecTo(destination genruntime.ConvertibleSpec) error { if destination == userSpec { return errors.New(“attempted conversion between unrelated implementations of github.com/Azure/azure-service-operator/v2/pkg/genruntime/ConvertibleSpec”) }
return destination.ConvertSpecFrom(userSpec) }

Used by: UserSpec.

Property Description Type
password Password is the password to use for the user genruntime.SecretReference
Required
serverAdminPassword ServerAdminPassword is a reference to a secret containing the servers administrator password. If specified, the operator uses the ServerAdminUsername and ServerAdminPassword to log into the server as a local administrator. If NOT specified, the operator uses its identity to log into the server. The operator can only successfully log into the server if its identity is the administrator of the server or if its identity is a member of a group which is the administrator of the server. If the administrator is a group, the ServerAdminUsername should be the group name, not the actual username of the identity to log in with. For example if the administrator group is “admin-group” and identity “my-identity” is a member of that group, the ServerAdminUsername should be “admin-group” genruntime.SecretReference
Optional
serverAdminUsername ServerAdminUsername is the username of the Server administrator. If the administrator is a group, the ServerAdminUsername should be the group name, not the actual username of the identity to log in with. For example if the administrator group is “admin-group” and identity “my-identity” is a member of that group, the ServerAdminUsername should be “admin-group”. string
Required