Guest user account missing........

[bbi]

What are the ramifications of the guest account not being present in the tempdb database. I have just been given a new client , who , when they reboot their SQL server, have to run a script that grants user access to a series of tables. The only thing I could see wrong with the setup is that the guest account is missing ( so I recreated it ) and that it didn't have the correct access permissions in the tempdb database.
Any suggestions will be greatly appreciated.

 

[tlbroadbent]

master, tempdb, pubs, msdb and northwind all have a guest user account and read permissions on all objects granted to public. Guest (user name) should not require individual permissions as the permissions are granted through the public role. tempdb is rebuilt every time SQL Server restarts so any updates you do are lost but that doesn't mean you lose permissions.

Bottom line - Don't worry about the guest user in tempdb. SQL will take care it for you. Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost