Get started
Yandex Managed Service for SQL Server™

UserService

A set of methods for managing SQL Server users.

Call Description
Get Returns the specified SQL Server user.
List Retrieves a list of SQL Server users in the specified cluster.
Create Creates an SQL Server user in the specified cluster.
Update Modifies the specified SQL Server user.
Delete Deletes the specified SQL Server user.
GrantPermission Grants a permission to the specified SQL Server user.
RevokePermission Revokes a permission from the specified SQL Server user.

Calls UserService

Get

Returns the specified SQL Server user.
To get the list of available SQL Server users, make a List request.

rpc Get (GetUserRequest) returns (User)

GetUserRequest

Field Description
cluster_id string
Required. ID of the SQL Server cluster the user belongs to.
To get the cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
user_name string
Required. Name of the SQL Server user to return.
To get the name of the user use a DatabaseService.List request. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_]*.

User

Field Description
name string
Name of the SQL Server user.
cluster_id string
ID of the SQL Server cluster the user belongs to.
permissions[] Permission
Set of permissions granted to the user.

Permission

Field Description
database_name string
Name of the database the permission grants access to.
roles[] enum Role
Roles granted to the user within the database. The minimum number of elements is 1.
  • DB_OWNER: Members of this fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database in SQL Server.
  • DB_SECURITYADMIN: Members of this fixed database role can modify role membership for custom roles only and manage permissions. They can potentially elevate their privileges and their actions should be monitored.
  • DB_ACCESSADMIN: Members of this fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins.
  • DB_BACKUPOPERATOR: Members of this fixed database role can back up the database.
  • DB_DDLADMIN: Members of this fixed database role can run any Data Definition Language (DDL) command in a database.
  • DB_DATAWRITER: Members of this fixed database role can add, delete, or change data in all user tables.
  • DB_DATAREADER: Members of this fixed database role can read all data from all user tables.
  • DB_DENYDATAWRITER: Members of this fixed database role cannot add, modify, or delete any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.
  • DB_DENYDATAREADER: Members of this fixed database role cannot read any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.

    List

    Retrieves a list of SQL Server users in the specified cluster.

    rpc List (ListUsersRequest) returns (ListUsersResponse)

    ListUsersRequest

    Field Description
    cluster_id string
    Required. ID of the cluster to list SQL Server users in.
    To get the cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
    page_size int64
    The maximum number of results per page to return. If the number of available results is larger than page_size, the service returns a ListUsersResponse.next_page_token that can be used to get the next page of results in subsequent list requests. Acceptable values are 0 to 1000, inclusive.
    page_token string
    Page token. To get the next page of results, set page_token to the ListUsersResponse.next_page_token returned by a previous list request. The maximum string length in characters is 100.

    ListUsersResponse

    Field Description
    users[] User
    Requested list of SQL Server users.
    next_page_token string
    Token that allows you to get the next page of results for list requests. If the number of results is larger than ListUsersRequest.page_size, use the next_page_token as the value for the ListUsersRequest.page_token parameter in the next list request. Each subsequent list request will have its own next_page_token to continue paging through the results.

    User

    Field Description
    name string
    Name of the SQL Server user.
    cluster_id string
    ID of the SQL Server cluster the user belongs to.
    permissions[] Permission
    Set of permissions granted to the user.

    Permission

    Field Description
    database_name string
    Name of the database the permission grants access to.
    roles[] enum Role
    Roles granted to the user within the database. The minimum number of elements is 1.
    • DB_OWNER: Members of this fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database in SQL Server.
    • DB_SECURITYADMIN: Members of this fixed database role can modify role membership for custom roles only and manage permissions. They can potentially elevate their privileges and their actions should be monitored.
    • DB_ACCESSADMIN: Members of this fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins.
    • DB_BACKUPOPERATOR: Members of this fixed database role can back up the database.
    • DB_DDLADMIN: Members of this fixed database role can run any Data Definition Language (DDL) command in a database.
    • DB_DATAWRITER: Members of this fixed database role can add, delete, or change data in all user tables.
    • DB_DATAREADER: Members of this fixed database role can read all data from all user tables.
    • DB_DENYDATAWRITER: Members of this fixed database role cannot add, modify, or delete any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.
    • DB_DENYDATAREADER: Members of this fixed database role cannot read any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.

      Create

      Creates an SQL Server user in the specified cluster.

      rpc Create (CreateUserRequest) returns (operation.Operation)

      Metadata and response of Operation:

          Operation.metadata:CreateUserMetadata

          Operation.response:User

      CreateUserRequest

      Field Description
      cluster_id string
      Required. ID of the SQL Server cluster to create a user for.
      To get the cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
      user_spec UserSpec
      Required. Properties of the user to be created.

      UserSpec

      Field Description
      name string
      Required. Name of the SQL Server user. The maximum string length in characters is 32. Value must match the regular expression [a-zA-Z0-9_]*.
      password string
      Required. Password of the SQL Server user. The string length in characters must be 8-128.
      permissions[] Permission
      Set of permissions to grant to the user.

      Permission

      Field Description
      database_name string
      Name of the database the permission grants access to.
      roles[] enum Role
      Roles granted to the user within the database. The minimum number of elements is 1.
      • DB_OWNER: Members of this fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database in SQL Server.
      • DB_SECURITYADMIN: Members of this fixed database role can modify role membership for custom roles only and manage permissions. They can potentially elevate their privileges and their actions should be monitored.
      • DB_ACCESSADMIN: Members of this fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins.
      • DB_BACKUPOPERATOR: Members of this fixed database role can back up the database.
      • DB_DDLADMIN: Members of this fixed database role can run any Data Definition Language (DDL) command in a database.
      • DB_DATAWRITER: Members of this fixed database role can add, delete, or change data in all user tables.
      • DB_DATAREADER: Members of this fixed database role can read all data from all user tables.
      • DB_DENYDATAWRITER: Members of this fixed database role cannot add, modify, or delete any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.
      • DB_DENYDATAREADER: Members of this fixed database role cannot read any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.

        Operation

        Field Description
        id string
        ID of the operation.
        description string
        Description of the operation. 0-256 characters long.
        created_at google.protobuf.Timestamp
        Creation timestamp.
        created_by string
        ID of the user or service account who initiated the operation.
        modified_at google.protobuf.Timestamp
        The time when the Operation resource was last modified.
        done bool
        If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
        metadata google.protobuf.Any<CreateUserMetadata>
        Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
        result oneof: error or response
        The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
          error google.rpc.Status
        The error result of the operation in case of failure or cancellation.
          response google.protobuf.Any<User>
        if operation finished successfully.

        CreateUserMetadata

        Field Description
        cluster_id string
        ID of the SQL Server cluster the user is being created for.
        user_name string
        Name of the user being created.

        User

        Field Description
        name string
        Name of the SQL Server user.
        cluster_id string
        ID of the SQL Server cluster the user belongs to.
        permissions[] Permission
        Set of permissions granted to the user.

        Permission

        Field Description
        database_name string
        Name of the database the permission grants access to.
        roles[] enum Role
        Roles granted to the user within the database. The minimum number of elements is 1.
        • DB_OWNER: Members of this fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database in SQL Server.
        • DB_SECURITYADMIN: Members of this fixed database role can modify role membership for custom roles only and manage permissions. They can potentially elevate their privileges and their actions should be monitored.
        • DB_ACCESSADMIN: Members of this fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins.
        • DB_BACKUPOPERATOR: Members of this fixed database role can back up the database.
        • DB_DDLADMIN: Members of this fixed database role can run any Data Definition Language (DDL) command in a database.
        • DB_DATAWRITER: Members of this fixed database role can add, delete, or change data in all user tables.
        • DB_DATAREADER: Members of this fixed database role can read all data from all user tables.
        • DB_DENYDATAWRITER: Members of this fixed database role cannot add, modify, or delete any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.
        • DB_DENYDATAREADER: Members of this fixed database role cannot read any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.

          Update

          Modifies the specified SQL Server user.

          rpc Update (UpdateUserRequest) returns (operation.Operation)

          Metadata and response of Operation:

              Operation.metadata:UpdateUserMetadata

              Operation.response:User

          UpdateUserRequest

          Field Description
          cluster_id string
          Required. ID of the SQL Server cluster the user belongs to.
          To get the cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
          user_name string
          Required. Name of the user to be updated.
          To get the name of the user use a UserService.List request. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_]*.
          update_mask google.protobuf.FieldMask
          Field mask that specifies which fields of the SQL Server user should be updated.
          password string
          New password for the user. The string length in characters must be 8-128.
          permissions[] Permission
          New set of permissions for the user.

          Permission

          Field Description
          database_name string
          Name of the database the permission grants access to.
          roles[] enum Role
          Roles granted to the user within the database. The minimum number of elements is 1.
          • DB_OWNER: Members of this fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database in SQL Server.
          • DB_SECURITYADMIN: Members of this fixed database role can modify role membership for custom roles only and manage permissions. They can potentially elevate their privileges and their actions should be monitored.
          • DB_ACCESSADMIN: Members of this fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins.
          • DB_BACKUPOPERATOR: Members of this fixed database role can back up the database.
          • DB_DDLADMIN: Members of this fixed database role can run any Data Definition Language (DDL) command in a database.
          • DB_DATAWRITER: Members of this fixed database role can add, delete, or change data in all user tables.
          • DB_DATAREADER: Members of this fixed database role can read all data from all user tables.
          • DB_DENYDATAWRITER: Members of this fixed database role cannot add, modify, or delete any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.
          • DB_DENYDATAREADER: Members of this fixed database role cannot read any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.

            Operation

            Field Description
            id string
            ID of the operation.
            description string
            Description of the operation. 0-256 characters long.
            created_at google.protobuf.Timestamp
            Creation timestamp.
            created_by string
            ID of the user or service account who initiated the operation.
            modified_at google.protobuf.Timestamp
            The time when the Operation resource was last modified.
            done bool
            If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
            metadata google.protobuf.Any<UpdateUserMetadata>
            Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
            result oneof: error or response
            The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
              error google.rpc.Status
            The error result of the operation in case of failure or cancellation.
              response google.protobuf.Any<User>
            if operation finished successfully.

            UpdateUserMetadata

            Field Description
            cluster_id string
            ID of the SQL Server cluster the user belongs to.
            user_name string
            Name of the user being updated.

            User

            Field Description
            name string
            Name of the SQL Server user.
            cluster_id string
            ID of the SQL Server cluster the user belongs to.
            permissions[] Permission
            Set of permissions granted to the user.

            Permission

            Field Description
            database_name string
            Name of the database the permission grants access to.
            roles[] enum Role
            Roles granted to the user within the database. The minimum number of elements is 1.
            • DB_OWNER: Members of this fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database in SQL Server.
            • DB_SECURITYADMIN: Members of this fixed database role can modify role membership for custom roles only and manage permissions. They can potentially elevate their privileges and their actions should be monitored.
            • DB_ACCESSADMIN: Members of this fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins.
            • DB_BACKUPOPERATOR: Members of this fixed database role can back up the database.
            • DB_DDLADMIN: Members of this fixed database role can run any Data Definition Language (DDL) command in a database.
            • DB_DATAWRITER: Members of this fixed database role can add, delete, or change data in all user tables.
            • DB_DATAREADER: Members of this fixed database role can read all data from all user tables.
            • DB_DENYDATAWRITER: Members of this fixed database role cannot add, modify, or delete any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.
            • DB_DENYDATAREADER: Members of this fixed database role cannot read any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.

              Delete

              Deletes the specified SQL Server user.

              rpc Delete (DeleteUserRequest) returns (operation.Operation)

              Metadata and response of Operation:

                  Operation.metadata:DeleteUserMetadata

                  Operation.response:google.protobuf.Empty

              DeleteUserRequest

              Field Description
              cluster_id string
              Required. ID of the SQL Server cluster the user belongs to.
              To get the cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
              user_name string
              Required. Name of the user to delete.
              To get the name of the user, use a UserService.List request. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_]*.

              Operation

              Field Description
              id string
              ID of the operation.
              description string
              Description of the operation. 0-256 characters long.
              created_at google.protobuf.Timestamp
              Creation timestamp.
              created_by string
              ID of the user or service account who initiated the operation.
              modified_at google.protobuf.Timestamp
              The time when the Operation resource was last modified.
              done bool
              If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
              metadata google.protobuf.Any<DeleteUserMetadata>
              Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
              result oneof: error or response
              The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
                error google.rpc.Status
              The error result of the operation in case of failure or cancellation.
                response google.protobuf.Any<google.protobuf.Empty>
              if operation finished successfully.

              DeleteUserMetadata

              Field Description
              cluster_id string
              ID of the SQL Server cluster the user belongs to.
              user_name string
              Name of the user being deleted.

              GrantPermission

              Grants a permission to the specified SQL Server user.

              rpc GrantPermission (GrantUserPermissionRequest) returns (operation.Operation)

              Metadata and response of Operation:

                  Operation.metadata:GrantUserPermissionMetadata

                  Operation.response:User

              GrantUserPermissionRequest

              Field Description
              cluster_id string
              Required. ID of the SQL Server cluster the user belongs to.
              To get the cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
              user_name string
              Required. Name of the user to grant the permission to. To get the name of the user, use a UserService.List request. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_]*.
              permission Permission
              Required. Permission that should be granted to the specified user.

              Permission

              Field Description
              database_name string
              Name of the database the permission grants access to.
              roles[] enum Role
              Roles granted to the user within the database. The minimum number of elements is 1.
              • DB_OWNER: Members of this fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database in SQL Server.
              • DB_SECURITYADMIN: Members of this fixed database role can modify role membership for custom roles only and manage permissions. They can potentially elevate their privileges and their actions should be monitored.
              • DB_ACCESSADMIN: Members of this fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins.
              • DB_BACKUPOPERATOR: Members of this fixed database role can back up the database.
              • DB_DDLADMIN: Members of this fixed database role can run any Data Definition Language (DDL) command in a database.
              • DB_DATAWRITER: Members of this fixed database role can add, delete, or change data in all user tables.
              • DB_DATAREADER: Members of this fixed database role can read all data from all user tables.
              • DB_DENYDATAWRITER: Members of this fixed database role cannot add, modify, or delete any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.
              • DB_DENYDATAREADER: Members of this fixed database role cannot read any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.

                Operation

                Field Description
                id string
                ID of the operation.
                description string
                Description of the operation. 0-256 characters long.
                created_at google.protobuf.Timestamp
                Creation timestamp.
                created_by string
                ID of the user or service account who initiated the operation.
                modified_at google.protobuf.Timestamp
                The time when the Operation resource was last modified.
                done bool
                If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
                metadata google.protobuf.Any<GrantUserPermissionMetadata>
                Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
                result oneof: error or response
                The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
                  error google.rpc.Status
                The error result of the operation in case of failure or cancellation.
                  response google.protobuf.Any<User>
                if operation finished successfully.

                GrantUserPermissionMetadata

                Field Description
                cluster_id string
                ID of the SQL Server cluster the user belongs to.
                To get the cluster ID, use a ClusterService.List request.
                user_name string
                Name of the user being granted a permission.

                User

                Field Description
                name string
                Name of the SQL Server user.
                cluster_id string
                ID of the SQL Server cluster the user belongs to.
                permissions[] Permission
                Set of permissions granted to the user.

                Permission

                Field Description
                database_name string
                Name of the database the permission grants access to.
                roles[] enum Role
                Roles granted to the user within the database. The minimum number of elements is 1.
                • DB_OWNER: Members of this fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database in SQL Server.
                • DB_SECURITYADMIN: Members of this fixed database role can modify role membership for custom roles only and manage permissions. They can potentially elevate their privileges and their actions should be monitored.
                • DB_ACCESSADMIN: Members of this fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins.
                • DB_BACKUPOPERATOR: Members of this fixed database role can back up the database.
                • DB_DDLADMIN: Members of this fixed database role can run any Data Definition Language (DDL) command in a database.
                • DB_DATAWRITER: Members of this fixed database role can add, delete, or change data in all user tables.
                • DB_DATAREADER: Members of this fixed database role can read all data from all user tables.
                • DB_DENYDATAWRITER: Members of this fixed database role cannot add, modify, or delete any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.
                • DB_DENYDATAREADER: Members of this fixed database role cannot read any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.

                  RevokePermission

                  Revokes a permission from the specified SQL Server user.

                  rpc RevokePermission (RevokeUserPermissionRequest) returns (operation.Operation)

                  Metadata and response of Operation:

                      Operation.metadata:RevokeUserPermissionMetadata

                      Operation.response:User

                  RevokeUserPermissionRequest

                  Field Description
                  cluster_id string
                  Required. ID of the SQL Server cluster the user belongs to.
                  To get the cluster ID, use a ClusterService.List request. The maximum string length in characters is 50.
                  user_name string
                  Required. Name of the user to revoke a permission from.
                  To get the name of the user, use a UserService.List request. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_]*.
                  permission Permission
                  Required. Permission that should be revoked from the specified user.

                  Permission

                  Field Description
                  database_name string
                  Name of the database the permission grants access to.
                  roles[] enum Role
                  Roles granted to the user within the database. The minimum number of elements is 1.
                  • DB_OWNER: Members of this fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database in SQL Server.
                  • DB_SECURITYADMIN: Members of this fixed database role can modify role membership for custom roles only and manage permissions. They can potentially elevate their privileges and their actions should be monitored.
                  • DB_ACCESSADMIN: Members of this fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins.
                  • DB_BACKUPOPERATOR: Members of this fixed database role can back up the database.
                  • DB_DDLADMIN: Members of this fixed database role can run any Data Definition Language (DDL) command in a database.
                  • DB_DATAWRITER: Members of this fixed database role can add, delete, or change data in all user tables.
                  • DB_DATAREADER: Members of this fixed database role can read all data from all user tables.
                  • DB_DENYDATAWRITER: Members of this fixed database role cannot add, modify, or delete any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.
                  • DB_DENYDATAREADER: Members of this fixed database role cannot read any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.

                    Operation

                    Field Description
                    id string
                    ID of the operation.
                    description string
                    Description of the operation. 0-256 characters long.
                    created_at google.protobuf.Timestamp
                    Creation timestamp.
                    created_by string
                    ID of the user or service account who initiated the operation.
                    modified_at google.protobuf.Timestamp
                    The time when the Operation resource was last modified.
                    done bool
                    If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
                    metadata google.protobuf.Any<RevokeUserPermissionMetadata>
                    Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
                    result oneof: error or response
                    The operation result. If done == false and there was no failure detected, neither error nor response is set. If done == false and there was a failure detected, error is set. If done == true, exactly one of error or response is set.
                      error google.rpc.Status
                    The error result of the operation in case of failure or cancellation.
                      response google.protobuf.Any<User>
                    if operation finished successfully.

                    RevokeUserPermissionMetadata

                    Field Description
                    cluster_id string
                    ID of the SQL Server cluster the user belongs to.
                    user_name string
                    Name of the user whose permission is being revoked.

                    User

                    Field Description
                    name string
                    Name of the SQL Server user.
                    cluster_id string
                    ID of the SQL Server cluster the user belongs to.
                    permissions[] Permission
                    Set of permissions granted to the user.

                    Permission

                    Field Description
                    database_name string
                    Name of the database the permission grants access to.
                    roles[] enum Role
                    Roles granted to the user within the database. The minimum number of elements is 1.
                    • DB_OWNER: Members of this fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database in SQL Server.
                    • DB_SECURITYADMIN: Members of this fixed database role can modify role membership for custom roles only and manage permissions. They can potentially elevate their privileges and their actions should be monitored.
                    • DB_ACCESSADMIN: Members of this fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins.
                    • DB_BACKUPOPERATOR: Members of this fixed database role can back up the database.
                    • DB_DDLADMIN: Members of this fixed database role can run any Data Definition Language (DDL) command in a database.
                    • DB_DATAWRITER: Members of this fixed database role can add, delete, or change data in all user tables.
                    • DB_DATAREADER: Members of this fixed database role can read all data from all user tables.
                    • DB_DENYDATAWRITER: Members of this fixed database role cannot add, modify, or delete any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.
                    • DB_DENYDATAREADER: Members of this fixed database role cannot read any data in the user tables within a database. Denial has a higher priority than a grant, so you can use this role to quickly restrict one's privileges without explicitly revoking permissions or roles.
                      In this article: