Search plugin: Or browse by category:

mssql-db-user summary

Plugin Name: mssql-db-user
Version: 0.0.5
Author: @melezhik
Realease Date: 2018-04-10 21:08:38
Short Description: Creates mssql user and grants permissions for database
Category: ---
Plugin web page: https://github.com/melezhik/mssql-db-user
Download link: mssql-db-user-v0.000005.tar.gz
Latest version link: https://sparrowhub.org/info/mssql-db-user

mssql-db-user documentation

mssql-db-user doc

SYNOPSIS

Creates mssql user and grants permissions for database.

Install

$ sparrow plg install mssql-db-user

USAGE

# create user with login and password
# and grant permissions to databases
$ sparrow plg run mssql-db-user \
  --param db_server={mssql server host} \
  --param db_admin={database server admin login} \
  --param db_pass={database server admin password} \
  --param db_user={user login}
  --param db_user_pass={user password}


$ only check that your db admin creds are valid


$ sparrow plg run mssql-db-user \
  --param db_server={mssql server host} \
  --param db_admin={database server admin login} \
  --param db_pass={database server admin password} \
  --param check_connection=on

Prerequisites

  • pwgen

  • sqlcmd client

Author

Alexey Melezhik