Microsoft SQL Server v0.1.0 published on Tuesday, Oct 8, 2024 by pulumiverse
mssql.getServerPermissions
Explore with Pulumi AI

Microsoft SQL Server v0.1.0 published on Tuesday, Oct 8, 2024 by pulumiverse
Returns all permissions grated to given principal
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as mssql from "@pulumi/mssql";
const exampleSqlLogin = mssql.getSqlLogin({
name: "example_login",
});
const exampleServerPermissions = exampleSqlLogin.then(exampleSqlLogin => mssql.getServerPermissions({
principalId: exampleSqlLogin.principalId,
}));
export const permissions = exampleServerPermissions.then(exampleServerPermissions => exampleServerPermissions.permissions);
import pulumi
import pulumi_mssql as mssql
example_sql_login = mssql.get_sql_login(name="example_login")
example_server_permissions = mssql.get_server_permissions(principal_id=example_sql_login.principal_id)
pulumi.export("permissions", example_server_permissions.permissions)
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 {
exampleSqlLogin, err := mssql.LookupSqlLogin(ctx, &mssql.LookupSqlLoginArgs{
Name: "example_login",
}, nil)
if err != nil {
return err
}
exampleServerPermissions, err := mssql.GetServerPermissions(ctx, &mssql.GetServerPermissionsArgs{
PrincipalId: exampleSqlLogin.PrincipalId,
}, nil)
if err != nil {
return err
}
ctx.Export("permissions", exampleServerPermissions.Permissions)
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Mssql = Pulumi.Mssql;
return await Deployment.RunAsync(() =>
{
var exampleSqlLogin = Mssql.GetSqlLogin.Invoke(new()
{
Name = "example_login",
});
var exampleServerPermissions = Mssql.GetServerPermissions.Invoke(new()
{
PrincipalId = exampleSqlLogin.Apply(getSqlLoginResult => getSqlLoginResult.PrincipalId),
});
return new Dictionary<string, object?>
{
["permissions"] = exampleServerPermissions.Apply(getServerPermissionsResult => getServerPermissionsResult.Permissions),
};
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.mssql.MssqlFunctions;
import com.pulumi.mssql.inputs.GetSqlLoginArgs;
import com.pulumi.mssql.inputs.GetServerPermissionsArgs;
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 exampleSqlLogin = MssqlFunctions.getSqlLogin(GetSqlLoginArgs.builder()
.name("example_login")
.build());
final var exampleServerPermissions = MssqlFunctions.getServerPermissions(GetServerPermissionsArgs.builder()
.principalId(exampleSqlLogin.applyValue(getSqlLoginResult -> getSqlLoginResult.principalId()))
.build());
ctx.export("permissions", exampleServerPermissions.applyValue(getServerPermissionsResult -> getServerPermissionsResult.permissions()));
}
}
variables:
exampleSqlLogin:
fn::invoke:
Function: mssql:getSqlLogin
Arguments:
name: example_login
exampleServerPermissions:
fn::invoke:
Function: mssql:getServerPermissions
Arguments:
principalId: ${exampleSqlLogin.principalId}
outputs:
permissions: ${exampleServerPermissions.permissions}
Using getServerPermissions
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 getServerPermissions(args: GetServerPermissionsArgs, opts?: InvokeOptions): Promise<GetServerPermissionsResult>
function getServerPermissionsOutput(args: GetServerPermissionsOutputArgs, opts?: InvokeOptions): Output<GetServerPermissionsResult>
def get_server_permissions(principal_id: Optional[str] = None,
opts: Optional[InvokeOptions] = None) -> GetServerPermissionsResult
def get_server_permissions_output(principal_id: Optional[pulumi.Input[str]] = None,
opts: Optional[InvokeOptions] = None) -> Output[GetServerPermissionsResult]
func GetServerPermissions(ctx *Context, args *GetServerPermissionsArgs, opts ...InvokeOption) (*GetServerPermissionsResult, error)
func GetServerPermissionsOutput(ctx *Context, args *GetServerPermissionsOutputArgs, opts ...InvokeOption) GetServerPermissionsResultOutput
> Note: This function is named GetServerPermissions
in the Go SDK.
public static class GetServerPermissions
{
public static Task<GetServerPermissionsResult> InvokeAsync(GetServerPermissionsArgs args, InvokeOptions? opts = null)
public static Output<GetServerPermissionsResult> Invoke(GetServerPermissionsInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetServerPermissionsResult> getServerPermissions(GetServerPermissionsArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
fn::invoke:
function: mssql:index/getServerPermissions:getServerPermissions
arguments:
# arguments dictionary
The following arguments are supported:
- Principal
Id string - ID of the principal who will be granted
permission
. Can be retrieved usingmssql.ServerRole
ormssql.SqlLogin
.
- Principal
Id string - ID of the principal who will be granted
permission
. Can be retrieved usingmssql.ServerRole
ormssql.SqlLogin
.
- principal
Id String - ID of the principal who will be granted
permission
. Can be retrieved usingmssql.ServerRole
ormssql.SqlLogin
.
- principal
Id string - ID of the principal who will be granted
permission
. Can be retrieved usingmssql.ServerRole
ormssql.SqlLogin
.
- principal_
id str - ID of the principal who will be granted
permission
. Can be retrieved usingmssql.ServerRole
ormssql.SqlLogin
.
- principal
Id String - ID of the principal who will be granted
permission
. Can be retrieved usingmssql.ServerRole
ormssql.SqlLogin
.
getServerPermissions Result
The following output properties are available:
- Id string
- Equals to
principal_id
. - Permissions
List<Pulumiverse.
Mssql. Outputs. Get Server Permissions Permission> - Set of permissions granted to the principal
- Principal
Id string - ID of the principal who will be granted
permission
. Can be retrieved usingmssql.ServerRole
ormssql.SqlLogin
.
- Id string
- Equals to
principal_id
. - Permissions
[]Get
Server Permissions Permission - Set of permissions granted to the principal
- Principal
Id string - ID of the principal who will be granted
permission
. Can be retrieved usingmssql.ServerRole
ormssql.SqlLogin
.
- id String
- Equals to
principal_id
. - permissions
List<Get
Server Permissions Permission> - Set of permissions granted to the principal
- principal
Id String - ID of the principal who will be granted
permission
. Can be retrieved usingmssql.ServerRole
ormssql.SqlLogin
.
- id string
- Equals to
principal_id
. - permissions
Get
Server Permissions Permission[] - Set of permissions granted to the principal
- principal
Id string - ID of the principal who will be granted
permission
. Can be retrieved usingmssql.ServerRole
ormssql.SqlLogin
.
- id str
- Equals to
principal_id
. - permissions
Sequence[Get
Server Permissions Permission] - Set of permissions granted to the principal
- principal_
id str - ID of the principal who will be granted
permission
. Can be retrieved usingmssql.ServerRole
ormssql.SqlLogin
.
- id String
- Equals to
principal_id
. - permissions List<Property Map>
- Set of permissions granted to the principal
- principal
Id String - ID of the principal who will be granted
permission
. Can be retrieved usingmssql.ServerRole
ormssql.SqlLogin
.
Supporting Types
GetServerPermissionsPermission
- Permission string
- Name of server-level SQL permission. For full list of supported permissions see docs
- With
Grant boolOption - When set to
true
,principal_id
will be allowed to grant thepermission
to other principals.
- Permission string
- Name of server-level SQL permission. For full list of supported permissions see docs
- With
Grant boolOption - When set to
true
,principal_id
will be allowed to grant thepermission
to other principals.
- permission String
- Name of server-level SQL permission. For full list of supported permissions see docs
- with
Grant BooleanOption - When set to
true
,principal_id
will be allowed to grant thepermission
to other principals.
- permission string
- Name of server-level SQL permission. For full list of supported permissions see docs
- with
Grant booleanOption - When set to
true
,principal_id
will be allowed to grant thepermission
to other principals.
- permission str
- Name of server-level SQL permission. For full list of supported permissions see docs
- with_
grant_ booloption - When set to
true
,principal_id
will be allowed to grant thepermission
to other principals.
- permission String
- Name of server-level SQL permission. For full list of supported permissions see docs
- with
Grant BooleanOption - When set to
true
,principal_id
will be allowed to grant thepermission
to other principals.
Package Details
- Repository
- mssql pulumiverse/pulumi-mssql
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
mssql
Terraform Provider.

Microsoft SQL Server v0.1.0 published on Tuesday, Oct 8, 2024 by pulumiverse