AddUsers - Adding Database Users

AddUsers - Adding Database Users

The AddUsers utility reads users from a PANTHEON database and creates SQL Server logins for the selected users. It can be downloaded from Datalab's FTP site. File is named AddUsers_PAX.exe.

This is handy, for example, when moving PANTHEON's database from one server instance to another, and the new instance has no logins created yet.

In the utility, specify connection parameters: Server and database name, and the sa (SysAdmin) login.

Click Fill users from Users table to read all users from PANTHEON's database.

Select the users for which you want to create SQL Server logins and their roles and click Create Users. A message will inform you when the operation is finished. Db_owner role is already filled for users that previously had this role (this information is stored in database backup - .bak). If user is not granted a db_owner (db_owner unchecked), then he automatically acquires db_datareader, db_datawriter and pax_data_owner.

On a right click menu there are options for easier selection:

Note that listed are all PANTHEON users, even inactive ones.