October 25, 2006 at 5:56 am
Is it possible to deny certain users the ability to create global temporary tables? I am setting up some logins with what I hoped were very limited permissions (to create views in one Db but not tables), but all seem to be able to create temp tables visible to any other user by default.
Any help would be most welcome!
Peter
October 25, 2006 at 6:52 am
To my knowledge you cannot except possibly by placing the user account in tempDB and explicitly denying create. However I have not got time to test this, this morning to see what other ramifications would come of this. But global temp tables are stored in tempDB, but so does some scratch tables for some query sets. Lastly every time you restart your server you would have to reconfigure as tempDB is destored and rebuilt. But would be worth at least testing to see the effect if for no other reason than the knowledge for yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply