Re: TempDB permissions

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 11/27/03 

Date: Thu, 27 Nov 2003 09:20:22 -0600

To add to Ryan's response, SELECT permissions on system objects are granted
to the public user by default so it appears someone changed the default
permissions.

Note that tempdb is recreated at SQL startup using the model database as a
template. Ensure the public role has SELECT permission on the system
objects in the model database. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Gert de Swardt" <anonymous@discussions.microsoft.com> wrote in message
news:0a5101c3b4cc$37bd5970$a101280a@phx.gbl...
> As of this past weekend, the following error msg keeps on
> popping up:
>
> SELECT permission denied on object 'sysobjects',
> database 'tempdb', owner 'dbo'.
>
> I had to go and give all the users read & write access to
> the tempDB. Do anyone know why this is happening and how
> to fix it?
>
> Regards
>
> Gert

Relevant Pages

  • Re: Remove permissions in default Public Role?
    ... The permissions granted to user defined objects can be ... permissions granted to the system objects. ... I create my own defined roles for each database and am ... assumming it's good to remove every single permission in the Public Role ...
    (microsoft.public.sqlserver.security)
  • Access privileges for PUBLIC User
    ... what System Views/Tables can i access to find out what ... permissions the PUBLIC user has been granted? ... Prev by Date: ...
    (comp.databases.oracle.server)