question

Wilfred van Dijk avatar image
Wilfred van Dijk asked

does it make sense to grant databaseroles in tempdb to a user?

I discovered some users have database roles on tempdb but is it useful? According to MS "any user can create temporary objects in tempdb" Are these permissions ignored? Some users have a deny_datareader role.

securitytempdb
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.