sql.azure.com/


User


User is an Azure SQL user

Used by: UserList.

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

UserSpec

Property Description Type
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
localUser LocalUser contains details for creating a standard (non-aad) Azure SQL User LocalUserSpec
Required
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 an sql.azure.com/ServersDatabase resource genruntime.KnownResourceReference
Required
roles The roles assigned to the user. See https://learn.microsoft.com/sql/relational-databases/security/authentication-access/database-level-roles?view=sql-server-ver16#fixed-database-roles for the fixed set of roles supported by Azure SQL. Roles include the following: db_owner, db_securityadmin, db_accessadmin, db_backupoperator, db_ddladmin, db_datawriter, db_datareader, db_denydatawriter, and db_denydatareader. 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
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
localUser LocalUser contains details for creating a standard (non-aad) Azure SQL User LocalUserSpec
Required
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 an sql.azure.com/ServersDatabase resource genruntime.KnownResourceReference
Required
roles The roles assigned to the user. See https://learn.microsoft.com/sql/relational-databases/security/authentication-access/database-level-roles?view=sql-server-ver16#fixed-database-roles for the fixed set of roles supported by Azure SQL. Roles include the following: db_owner, db_securityadmin, db_accessadmin, db_backupoperator, db_ddladmin, db_datawriter, db_datareader, db_denydatawriter, and db_denydatareader. string[]
Optional

UserStatus

Used by: User.

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

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. genruntime.SecretReference
Required
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