CODEWITHSUNDEEP
sql-serverpermissionstempdb
Farshid SQLServer
Farshid SQLServer

Reputation: 3

Direct access to tempdb

An application vendor representative asked me to grant dbowner access to tempdb for their application login; to be able to create objects in tempdb without "#" or "##" prefixes. I tried to convince him to forget asking for direct tempdb access by arguing that granting direct access may interfere with SQL Server engine internal operations and prevent tempdb cleanup processes to do their jobs correctly. And also there is another drawback on SQL Service restarts which causes any permission setting on tempdb to revert to defaults.

Is there anything that I might miss in this regard?

Upvotes: 0

Views: 275

Answers (0)

Related Questions