Database User Management

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner, and under Databases, click Data Admin Service.
4. In the navigation pane on the left, choose Development Tool.

   You can also click Go to Development Tool on the overview page.

5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
6. On the top menu bar, choose Account Management > Database User Management.
7. On the displayed page, select a database and click Create User.
   Figure 1 Database user management
   

8. On the displayed page, set parameters on the Basic Settings, Owned Schemas, Membership, and Securables tab pages separately, and click Save.
   Figure 2 Creating a user
   

   Table 1 Database user information

   Parameter	Description
   User Type	You can select SQL user with login or SQL user without login. Users without login names cannot log in, but they can be assigned permissions.
   Username	Name of the database user.
   Login Name	Login name associated with the database user. When the database user logs in to a database using the login name, the permissions of the login name are also the permissions of the database user.
   Default Schema	The first schema that the server searches for when it resolves object names for this database user.
   Owned Schemas	All schemas owned by the database user.
   Membership	All roles owned by the database user. If a user has a role, it has all permissions of the role.
   Securables	The user's specific permissions on database objects.

9. After configuring required parameters, click Save. In the preview dialog box, click OK.
10. In the user management list, edit, rename, or delete the created users.