Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2012
    Posts
    12

    Unanswered: Permissions issue on table in tempdb

    Bonjour,
    I needed a backup copy of a table for an application modification. I have created the table as a select * into tempdb..mybackuptable from mydb..originaltable.

    The problem is, no one except me (SA) can access the table in tempdb.

    SELECT permission denied on object mybackuptable, database tempdb, owner dbo

    I tried to grant permission but there are no users un tempdb so you can't. I tried to change to owner of the table guest and returned : "Cannot transfert object ownership to user 'guest'".

    Besides droping the table and explicitely create is as tempdb.guest.mybackuptable, what could I do?

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Try grant select on tempdb.. mybackuptable to public
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    Mar 2012
    Posts
    12
    Haaaaaaaaaaaaaaaaa! Thanks Martijnvs! It works like a charm!

    Cheers!

  4. #4
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    You're welcome
    I'm not crazy, I'm an aeroplane!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •