Database User Management

Procedure

1. On the top menu bar, choose Account Management > Database User Management.
2. On the displayed page, select a database and click Create User.
3. Configure parameters on Basic Settings, Owned Schemas, Membership, and Securables pages by referring to Table 1, and click Save.

   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 database user's specific permissions on database objects

4. In the displayed SQL Preview dialog box, click OK.
5. In the user management list, edit, rename, or delete the created users.