Post reply

Roles on tempdb

  • June 9, 2023 at 7:16 pm

    #4208026

    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?

  • June 10, 2023 at 8:10 pm

    #4208621

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

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

  • June 22, 2023 at 6:28 pm

    #4216973

    The model database has roles

  • July 26, 2023 at 5:04 am

    #4244704

    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