Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2007-05-02 : 11:10:20
|
| Hi,We have a problem here where there is a request to grant dbo access to tempdb as the application developers are trying to create a global temporary table inside tempdb database. The SQL login does a bulk insert to the temporary table in tempdb ans then loads it in a permanent table inside one user database. Howeever the job is failing with message as :" The current user is not the database or object owner of table '<table_name>'. Cannot perform SET operation. "I checked the MS article and it says that DBO permissions needs to be granted for tempdb database. We want to avoid that and would like to know is there is any alternative way where the SQL id could be granted privileges to create , alter , delete and insert tables straight inside the user db ( not tempdb ) without DBO access. The program will run as and when required and everytime it will creat a new table. Any ways to address this alternatively would be of great help. Thank you. |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-05-02 : 11:12:51
|
| Since this is SQL 2005, why not allow them to create a table in their own schema in the user database (i.e. not tempdb). This would give them ownership of the table, and therefore the rights to bulk insert into it. |
 |
|
|
|
|
|
Permission issue !!