T-SQLRevoke permissions to all tables in the sql server in one go How can we revoke a certain permission to all tables?

I've tried (T-SQL):

REVOKE SELECT on schema::DBO TO [public] AS [dbo]


But nothing happens.. All tables still have Select permission.

I can take one by one

REVOKE SELECT on  dbo.table TO [public] AS [dbo]


One by one works ok.

How to revoke permissions from all tables of a specific schema in one go? 

Do I need to build  a cursor for this?
you can try

EXEC sp_MSforeachtable @command1 = 'PRINT (''REVOKE SELECT on ? TO [Role] AS [dbo]'')'


and instead of print

EXEC sp_MSforeachtable @command1 = 'REVOKE SELECT on ? TO [Role] AS [dbo]'