mssql

Documentation

Index

• type CreateUser
• type DatabaseGrantPermission
• type Role
• type RoleMembership
• type SqlClient
  • func NewClient(host string, port int64, database string, username string, password string) SqlClient
• type UpdateUser
• type User

Types

type CreateUser

type CreateUser struct {
	Username      string
	Password      string
	Sid           string
	External      bool
	DefaultSchema string
}

type DatabaseGrantPermission

type DatabaseGrantPermission struct {
	Id         string
	Principal  string
	Permission string
}

type Role

type Role struct {
	Id   string
	Name string
}

type RoleMembership

type RoleMembership struct {
	Id     string
	Role   string
	Member string
}

type SqlClient

type SqlClient interface {
	GetUser(ctx context.Context, username string) (User, error)
	CreateUser(ctx context.Context, create CreateUser) (User, error)
	UpdateUser(ctx context.Context, update UpdateUser) (User, error)
	DeleteUser(ctx context.Context, username string) error
	ReadRoleMembership(ctx context.Context, id string) (RoleMembership, error)
	AssignRole(ctx context.Context, role string, principal string) (RoleMembership, error)
	UnassignRole(ctx context.Context, role string, principal string) error
	ReadDatabasePermission(ctx context.Context, id string) (DatabaseGrantPermission, error)
	GrantDatabasePermission(ctx context.Context, principal string, permission string) (DatabaseGrantPermission, error)
	RevokeDatabasePermission(ctx context.Context, principal string, permission string) error
	GetRole(ctx context.Context, name string) (Role, error)
	CreateRole(ctx context.Context, name string) (Role, error)
	UpdateRole(ctx context.Context, role Role) (Role, error)
	DeleteRole(ctx context.Context, name string) error
}

func NewClient

func NewClient(host string, port int64, database string, username string, password string) SqlClient

type UpdateUser

type UpdateUser struct {
	Id            string
	Password      string
	DefaultSchema string
}

type User

type User struct {
	Id            string
	Username      string
	Type          string
	Sid           string
	External      bool
	DefaultSchema string
}