SQL $-$ I do not have permission to create users but I need to write the code as if I did.

Scenario:

You are the database administrator for a company that uses SQL Server. The task is to create a script that automates the process of creating users and setting permissions for them.

Requirements:

$1.$ Write a T$-$SQL script that connects to the SQL Server database.

$2.$ The script should create two users: 'user$1\text{'}$ and 'user$2\text{'}.$

$3.$ Set appropriate permissions for each user:

'user$1\text{'}$ should have read$-$only access to $\text{'}$mydb$\text{'}$ database. 'user$2\text{'}$ should have read and write access to 'otherdb' database.