Post reply

TempDB permissions

  • November 27, 2003 at 2:45 am

    #83494

    Hi Guys/Gals,

    Since the beginning of the week I have had some problems with my production box. The following error keeps on popping up:

    SELECT permission denied on object 'sysobjects', database 'tempdb', owner 'dbo'.

    I now had to go and give all the users read & write access to TempDB. DO anyone perhaps have an answer how to correct it?

    Regards

  • November 27, 2003 at 5:48 am

    #483902

    Did anyone remove the guest user or change its permissions in any way for this database?

    K. Brian Kelley, GSEC

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

  • November 27, 2003 at 9:08 am

    #483933

    Hi Brian,

    The guest is still there and the permissions are still the same as all the other servers. What I did check was the public role. It is still there and guest is still in it, but the permissions for the role changed.

    Thanx for the help(even if it was indirect ;))

    Regards

    Gert

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

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