After creating an account for the SQL Server instance, you need to manually grant database permissions to the advanced account and the ordinary account.

Grant account permission

1. On the account management page, click Authorize.

2. In the unauthorized database, select the database to be authorized, click the arrow to the right, and move the database to the authorized database on the right. There are multiple databases, which can be selected in batch for moving.

3. Grant account permission

In an authorized database, you can set permissions as read-write, read-only, and owner.

Remove account authorization

In the authorized database, click to select the database whose permission needs to be removed, click the arrow to the left, move the database to the unauthorized database on the left, or click X Symbol removal account authorization