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

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