Skip to content

Log in to the database management platform for instance

In the instance list of MatrixOne Intelligence instance management platform, find the instance you want to connect to, clickConnect >Connect through cloud platform to enter the instance login page, and then enter the username and password to successfully log in to the instance's database management platform. You can log in with admin users or regular users. For more descriptions of admin users and regular users, please see Permission Management in MatrixOne Intelligence.

admin user

The default login user of the instance's database management platform is admin, and the admin user password is specified when creating the instance.

Normal user

In addition to using admin users to log in to the instance's database management platform, it also supports access to ordinary users, as long as the corresponding permission is granted.

step:

  • Create a new user

After logging in with admin user, create a new user

create user u2 identified by '123456';
  • Create a new role

In tenants, users cannot do anything without being assigned a role. For details, please see [Role-based Access Control] (../Security/about-privilege-management.md). So we need to create a new role.

create role if not exists role2;
  • Authorization

Grant the object permissions to the role and then assign the role to the user. At this time, the user can operate on the object. If you are not authorized, then ordinary users can only view the query history information after logging in. If other operations are required, the corresponding permissions should be granted. For details, please see Permission Management in MatrixOne Intelligence. Perform the following to assign the highest permissions to the role.

grant all on account * to role2;
grant all on database * to role2;
grant all on table *.* to role2;
grant role2 to u2;
  • Log in

If you want to log in to the instance's database management platform as an ordinary user, the format of the user name should be "User name: Role name", such as "u2:role2". If you do not fill in the role name, the default role is public.