Post reply

Using UDT in SQL Server 2005 TempDB

  • January 17, 2007 at 9:31 pm

    #117068

    I have certain User Defined Data Types in my Database. The same are also present in the TempDB also. Now from the SPs when I am trying to create a Hash Table by using the Create Table #Temp (Amount UDT) the server is throwing a Permission related error. This is because the user through which I have logged into SQL Server 2005 does not have DBO permission, i.e. I haven't logged into as User : 'sa'. If u give DBO permission to the user that I have used to login then I can perform the same job of Create Table #Temp (Amount UDT).

  • January 22, 2007 at 12:08 pm

    #684763

    May be it is by desing for security reasons so why don't you grant to dbo to use in tempdb...

     

    MohammedU
    Microsoft SQL Server MVP

  • January 23, 2007 at 10:17 pm

    #685134

    Client will not allow the application user dbo rights. Thats why I have this problem. Granting dbo rights to the Application user will solve the same I know. Actually the application was running all right with SQL Server 2000. Now the client is migrating to SQL 2005 and there lies all the headache...

  • January 23, 2007 at 11:03 pm

    #685139

    Client can be convinced because dbo right be given in tempdb not in user database..

     

    MohammedU
    Microsoft SQL Server MVP

Viewing 4 posts - 1 through 4 (of 4 total)

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