Roles on tempdb

  • A co-worker asked me a question today and I couldn't come up with an answer, or find one online that seemed definitive...

    Is there any purpose for the roles on tempdb (db_datareader, db_datawriter, etc.) or are they just there because "it's a database" and SQL Server doesn't exclude it from having roles?  They get blown away when SQL is restarted anyway, so I assume the latter...

    But just wondering...  has anyone actually used these for anything, and if so, what?

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • The model database has roles

  • From msdn :

    Any user can create temporary objects in tempdb. Users can access only their own objects, unless they receive additional permissions. It's possible to revoke the connect permission to tempdb to prevent a user from using tempdb. We don't recommend it because some routine operations require the use of tempdb.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply