SQL access control error: Insufficient privileges to operate on schema 'INFORMATION_SCHEMA'

Question

When I am trying to execute the below query GRANT USAGE on INFORMATION_SCHEMA, I am getting below error

GRANT MONITOR ON SCHEMA DEMO_DB.INFORMATION_SCHEMA TO ROLE ALATIONTEST; GRANT USAGE ON SCHEMA DEMO_DB.INFORMATION_SCHEMA TO ROLE ALATIONTEST;

I have tried with different roles SYSADMIN, ACCOUNTADMIN, SECURITYADMIN still no luck.

Also, I could run the above GRANT query for other schemas, Only getting error with INFORMATION_SCHEMA

Please help on this.

Does the answer here help? stackoverflow.com/questions/58294920/… — Suzy Lockwood
What problem are you having that requires you to grant access to the information_schema? Is the alation role not able to see the information_schema for a database? — Simon D
I need to fetch the Metadata of all the schema, tables, columns from the respective DB from INFORMATION_SCHEMA. So for that, Do I need to provide the privilege to my service account? — Vathinth T

Mike Walton Mike Walton · Accepted Answer · 2020-05-15T16:51:26

The INFORMATION_SCHEMA schema is read-only for all users. No explicit grants to that schema are necessary.