Microsoft SQL Server v0.1.0 published on Tuesday, Oct 8, 2024 by pulumiverse
mssql.getServerRoles
Start a Neo task
Explain and create a mssql.getServerRoles resource
Microsoft SQL Server v0.1.0 published on Tuesday, Oct 8, 2024 by pulumiverse
Obtains information about all roles defined in the server.
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as mssql from "@pulumi/mssql";
const all = mssql.getServerRoles({});
export const roles = all.then(all => all.roles);
import pulumi
import pulumi_mssql as mssql
all = mssql.get_server_roles()
pulumi.export("roles", all.roles)
package main
import (
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
"github.com/pulumiverse/pulumi-mssql/sdk/go/mssql"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
all, err := mssql.GetServerRoles(ctx, nil, nil)
if err != nil {
return err
}
ctx.Export("roles", all.Roles)
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Mssql = Pulumi.Mssql;
return await Deployment.RunAsync(() =>
{
var all = Mssql.GetServerRoles.Invoke();
return new Dictionary<string, object?>
{
["roles"] = all.Apply(getServerRolesResult => getServerRolesResult.Roles),
};
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.mssql.MssqlFunctions;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
final var all = MssqlFunctions.getServerRoles();
ctx.export("roles", all.applyValue(getServerRolesResult -> getServerRolesResult.roles()));
}
}
variables:
all:
fn::invoke:
Function: mssql:getServerRoles
Arguments: {}
outputs:
roles: ${all.roles}
Using getServerRoles
Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.
function getServerRoles(opts?: InvokeOptions): Promise<GetServerRolesResult>
function getServerRolesOutput(opts?: InvokeOptions): Output<GetServerRolesResult>def get_server_roles(opts: Optional[InvokeOptions] = None) -> GetServerRolesResult
def get_server_roles_output(opts: Optional[InvokeOptions] = None) -> Output[GetServerRolesResult]func GetServerRoles(ctx *Context, opts ...InvokeOption) (*GetServerRolesResult, error)
func GetServerRolesOutput(ctx *Context, opts ...InvokeOption) GetServerRolesResultOutput> Note: This function is named GetServerRoles in the Go SDK.
public static class GetServerRoles
{
public static Task<GetServerRolesResult> InvokeAsync(InvokeOptions? opts = null)
public static Output<GetServerRolesResult> Invoke(InvokeOptions? opts = null)
}public static CompletableFuture<GetServerRolesResult> getServerRoles(InvokeOptions options)
public static Output<GetServerRolesResult> getServerRoles(InvokeOptions options)
fn::invoke:
function: mssql:index/getServerRoles:getServerRoles
arguments:
# arguments dictionarygetServerRoles Result
The following output properties are available:
- Id string
- Roles
List<Pulumiverse.
Mssql. Outputs. Get Server Roles Role> - Set of all roles found in the server
- Id string
- Roles
[]Get
Server Roles Role - Set of all roles found in the server
- id String
- roles
List<Get
Server Roles Role> - Set of all roles found in the server
- id string
- roles
Get
Server Roles Role[] - Set of all roles found in the server
- id str
- roles
Sequence[Get
Server Roles Role] - Set of all roles found in the server
- id String
- roles List<Property Map>
- Set of all roles found in the server
Supporting Types
GetServerRolesRole
- Id string
- Role principal ID.
- Name string
- Role name. Must follow Regular Identifiers rules and cannot be longer than 128 chars.
- Owner
Id string - ID of another server role or login owning this role. Can be retrieved using
mssql.ServerRoleormssql.SqlLogin.
- Id string
- Role principal ID.
- Name string
- Role name. Must follow Regular Identifiers rules and cannot be longer than 128 chars.
- Owner
Id string - ID of another server role or login owning this role. Can be retrieved using
mssql.ServerRoleormssql.SqlLogin.
- id String
- Role principal ID.
- name String
- Role name. Must follow Regular Identifiers rules and cannot be longer than 128 chars.
- owner
Id String - ID of another server role or login owning this role. Can be retrieved using
mssql.ServerRoleormssql.SqlLogin.
- id string
- Role principal ID.
- name string
- Role name. Must follow Regular Identifiers rules and cannot be longer than 128 chars.
- owner
Id string - ID of another server role or login owning this role. Can be retrieved using
mssql.ServerRoleormssql.SqlLogin.
- id str
- Role principal ID.
- name str
- Role name. Must follow Regular Identifiers rules and cannot be longer than 128 chars.
- owner_
id str - ID of another server role or login owning this role. Can be retrieved using
mssql.ServerRoleormssql.SqlLogin.
- id String
- Role principal ID.
- name String
- Role name. Must follow Regular Identifiers rules and cannot be longer than 128 chars.
- owner
Id String - ID of another server role or login owning this role. Can be retrieved using
mssql.ServerRoleormssql.SqlLogin.
Package Details
- Repository
- mssql pulumiverse/pulumi-mssql
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
mssqlTerraform Provider.
Microsoft SQL Server v0.1.0 published on Tuesday, Oct 8, 2024 by pulumiverse
