Grant SELECT on MySQL tables except a few tables
Task: Grant SELECT access on tables in vos3000db schema except a few tables (which contains user credentials and security information) to another newly created MySQL user which will be used by billing department. Connection to MySQL server will only be allowed from billing application server. Each day a new table is creating in MySQL vos3000db schema.…