# SqlServerProxy.createRoleAssignment

- Module: [Aspire.Hosting.Azure.Provisioning.Sql](/reference/api/typescript/aspire.hosting.azure.provisioning.sql.md)
- Defined on: [SqlServerProxy](/reference/api/typescript/aspire.hosting.azure.provisioning.sql/sqlserverproxy.md)
- Version: `13.6.0-preview.1.26478.8`
- Kind: `method`

Invokes CreateRoleAssignment on the SqlServer provisioning model.

## Definition

```typescript
interface SqlServerProxy {
  // ... omitted for brevity
  createRoleAssignment(
      role: SqlBuiltInRoleProxy,
      principalType: BicepValueProxy | RoleManagementPrincipalType,
      principalId: BicepValueProxy | guid,
      bicepIdentifierSuffix: string): SqlRoleAssignmentProxy;
}
```

## Signature

```typescript
createRoleAssignment(
    role: SqlBuiltInRoleProxy,
    principalType: BicepValueProxy | RoleManagementPrincipalType,
    principalId: BicepValueProxy | guid,
    bicepIdentifierSuffix: string): SqlRoleAssignmentProxy
```

## Parameters

- `role` ([SqlBuiltInRoleProxy](/reference/api/typescript/aspire.hosting.azure.provisioning.sql/sqlbuiltinroleproxy.md))
- `principalType` (`BicepValueProxy | RoleManagementPrincipalType`)
- `principalId` (`BicepValueProxy | guid`)
- `bicepIdentifierSuffix` (`string`)

## Returns

[SqlRoleAssignmentProxy](/reference/api/typescript/aspire.hosting.azure.provisioning.sql/sqlroleassignmentproxy.md)

## Defined on

- [SqlServerProxy](/reference/api/typescript/aspire.hosting.azure.provisioning.sql/sqlserverproxy.md) -- `handle`