Method, system, and device for managing database permissions, and computer-readable storage medium

A device for managing database permissions, the device comprising a memory, a processor, and a database permission management program that is stored in the memory and that is operable on the processor, the processor being configured to execute the database permission management program to perform the following operations;

• obtaining a login account that successfully logs in to a first database, the first database being a relational database built in with permission management wherein the first database is pre-configured with an external table that has a mapping relationship with a second database;
• data stored in the second database is synchronized to the external table, and an operation on the external table or on data in the external table is synchronized to the second database, the second database is inserted into the first database in the form of the external table;
• and the second database is a non-relational database and does not have permission management functionality;
• ascertaining management permissions of the login account based on pre-configured management permission information;
• determining whether a management operation on the external table by the login account exceeds the management permissions of the login account;
• and
• in response to the management operation by the login account does not exceed its management permissions, permitting the management operation, and synchronizing the management operation to the second database based on the mapping relationship between the external table and the second database.

A non-transitory computer-readable storage medium having stored therein a database permission management program, the database permission management program when executed by a processor performing the following operations:

• obtaining a login account that successfully logs in to a first database, the first database being a relational database built in with permission management wherein the first database is pre-configured with an external table that has a mapping relationship with a second database;
• data stored in the second database is synchronized to the external table, and an operation on the external table or on data in the external table is synchronized to the second database, and the second database is inserted into the first database in the form of the external table;
• and the second database is a non-relational database and does not have permission management functionality;
• ascertaining management permissions of the login account based on pre-configured management permission information;
• determining whether a management operation on the external table by the login account exceeds the management permissions of the login account;
• and
• in response to the management operation by the login account does not exceed its management permissions, permitting the management operation, and synchronizing the management operation to the second database based on the mapping relationship between the external table and the second database.