Does "cfuser" have the below? db_owner db_ddladmin db_datareader db_datawriter
"cfuser" should have the above privileges to be able to create objects as dbo. Joe ----- Original Message ----- From: "Brook Davies" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 09, 2002 7:13 PM Subject: Bulk Insert > I wonder if any one can help with this one. SQL Server management is not my > strongest skill :) I'm using a SQL Server login account via CF (cfuser). > When I create a table via CF, the tables owner is "cfuser" rather than DBO. > This is fine, until I try to do a BULK INSERT and get an error on the > opentable statement. I can run the BULK INSERT on any of the tables owned > by dbo. > > I set up a new account, with sys_admin privileges and even this account can > not run the BULK INSERT. Another funny thing is the owner account (cfuser) > can also not run the BULK INSERT. Does any one know why this would be? > > Thanks :) > Brook Davies > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
