sql-server add tag
Joe Obbish
By default, end users can query `tempdb.sys.tables` to get a full list of tables and they can read data from any of the global temporary tables. Is there a way to prevent end users from getting a list of all temporary tables?

The background is that The Application uses global temporary tables for certain ETL tasks. I would prefer for end users to not be able to look at the data in those tables. Please assume that changing to local temporary tables is not an option.

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.