Post reply

Tempdb access rights problem (sql2K)

  • September 25, 2003 at 6:32 am

    #160776

    I'm having an odd problem with tempdb.

    I have moved tempdb to another drive, locked down the developers to dbo rights from SA on the dev server and applied the windows patches for msblaster. Now every time I restart the server or SQL they loose permission to create tables in tempdb with "#tablename" unless I give the logins dbo rights on tempdb manually after every reboot. What have I missed, its driving me nuts as it was OK before.

  • September 25, 2003 at 7:53 am

    #475803

    Did you remove 'guest' user or block it from TempDB?

  • September 25, 2003 at 9:04 am

    #475828

    Got DBO and Guest as logins on tempdb

  • September 25, 2003 at 9:14 am

    #475832

    Any changes on permissions on 'guest' user in TempDB?

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

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