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 |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2006-05-10 : 13:26:59
|
| I have a dts job that i set up user and get the error messageThe current user is not the database or object owner of table 'dbo.ET_CHRG'. Cannot perform SET operation.My user is called PRTCIMPORTS.The dts job actually doesosql -E -S server -i "\\myserver\myfile.sQL"the myfile.sql has a blk insert commandUSE TEMPDBif exists (select * from dbo.sysobjects where id = object_id(N'[ET_CHRG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)DROP TABLE ET_CHRGCREATE TABLE ET_CHRG(COL1 VARCHAR(100),COL2 VARCHAR(100),COL3 VARCHAR(100),COL4 VARCHAR(100),)BULK INSERT ET_CHRG FROM '\\server\ET_CHRG.txt' WITH (DATAFILETYPE = 'char', FIELDTERMINATOR = ',', ROWTERMINATOR = '\n') I have the user set up in security logins.When i do not set the server role to system administration it will not work. I tried just the Bulk insert administrator and removing system administration i get the error above. Any ideas. |
|
|
|
|
|
user login security permissions