Thank you very much for the code.

The tables are not visible but, I can still see the data by select query.

How can I change in

I the following code possible

select name,'DENY SELECT DEFINITION ON ' + QUOTENAME(name) + ' TO VirtualOfficeReport '

from sys.objects

where type_desc IN('USER_TABLE',

'SQL_STORED_PROCEDURE',

'AGGREGATE_FUNCTION',

'SQL_INLINE_TABLE_VALUED_FUNCTION',

'SQL_TABLE_VALUED_FUNCTION',

'SQL_SCALAR_FUNCTION')