I can't create a table in TEMPDB

I have a USER wich can Create tables in the production DB, but this USER
can't create tables in TEMPDB.
? What's grong ?Does the user have access to TEMPDB database?
"Eduardo6973" <Eduardo6973@.discussions.microsoft.com> wrote in message
news:DC6F4810-17F5-4E3E-A59B-EAE30255E02F@.microsoft.com...
>I have a USER wich can Create tables in the production DB, but this USER
> can't create tables in TEMPDB.
> What's grong ?|||It's unusual to create non-temporary tables in tempdb. Can you elaborate on
why you need to do this? Perhaps there is an alternate approach.
All users have permissions to create local or global temp tables in tempdb
but CREATE TABLE permission is needed to create 'permanent' tables.
Non-sysadmin role members access tempdb under the guest user security
context so you could grant CREATE TABLE to guest so that non-sysadmin users
can create permanent tables owned by guest in tempdb. Alternatively, you
could add users to tempdb and then grant CREATE TABLE permissions to those
users. However, note that tempdb is recreated at instance startup so all
users, permissions and objects created in tempdb will lost. You'll need to
either reapply those permissions at startup or add the permissions to the
model database.
Hope this helps.
Dan Guzman
SQL Server MVP
"Eduardo6973" <Eduardo6973@.discussions.microsoft.com> wrote in message
news:DC6F4810-17F5-4E3E-A59B-EAE30255E02F@.microsoft.com...
>I have a USER wich can Create tables in the production DB, but this USER
> can't create tables in TEMPDB.
> What's grong ?