Question 1: How does one implement read authorization only for the specified database with the specified user name? Question 2: the website has many Members who want to outsource some website functions to third-party companies, but I don't want to disclose member data to them, how to control the specified number of accesses to the member table or the target table... question 1: How does one implement read authorization only for the specified database with the specified user name?
Question 2: the website has many Members who want to outsource some website functions to third-party companies, but I don't want to disclose member data to them, how to control the access to specified data from the member table or the target table? For example, the member table can only access testuser1 and testuser2.
Reply content:
Question 1: How does one implement read authorization only for the specified database with the specified user name?
Question 2: the website has many Members who want to outsource some website functions to third-party companies, but I don't want to disclose member data to them, how to control the access to specified data from the member table or the target table? For example, the member table can only access testuser1 and testuser2.
Create another mysql account, assign permissions to the account, and specify the tables to be queryable and writable.