Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:users-guide:check-list:setting-up-source-user-privileges [May 07, 2018, 03:15:36 PM]
127.0.0.1 external edit
sqlways:users-guide:check-list:setting-up-source-user-privileges [May 17, 2018, 09:52:47 AM] (current)
alexandr.kirpichny [Microsoft SQL Server]
Line 39: Line 39:
   * create login sql_test with password = 'Pwd'     * create login sql_test with password = 'Pwd'  
   * alter  login sql_test with  default_database = test  -- Assign the default database 'test' for the login   * alter  login sql_test with  default_database = test  -- Assign the default database 'test' for the login
 +  * use test                                             -- We need to create user in the required database, so we need to use it
   * create user test_user for login sql_test   * create user test_user for login sql_test
  
sqlways/users-guide/check-list/setting-up-source-user-privileges.txt · Last modified: May 17, 2018, 09:52:47 AM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement