Sys scema and Information schema permissions

Question

I have SQL Server 2008 R2.

I have denied SELECT on all [sys] schema, and INFOMRATION_SCHEMA objects for a user.

But the user has to be able SELECT from INFOMRATION_SCHEMA.PARAMETERS, but despite the REVOKE:

REVOKE SELECT ON OBJECT::[INFORMATION_SCHEMA].[PARAMETERS] to myUser;

the user still cannot select from that table/view.

I guess I have to REVOKE more, previously DENIED permissions on those system views/tables, but not sure which.

Any thought?

Answer 1

Its not another [sys] table, but DENY VIEW DEFINITION permission which blocked me.

Answer 2

Have you tried:

REVOKE SELECT ON OBJECT::[INFORMATION_SCHEMA].[PARAMETERS] FROM myUser;

Note the change with keyword FROM. Examples are shown on Microsoft's website here.