RE: losing permisions in tempdb

From: Stephen Strong (anonymous_at_discussions.microsoft.com)
Date: 04/02/04


Date: Thu, 1 Apr 2004 15:41:05 -0800

Generally you shouldn't be granting permissions to users in tempdb. What is the requirement for this? (As Sue said, tempdb gets rebuilt every time the SQL Instance or server is restarted - this is a desirable thing).