check that you have granted Select/Insert/Update privileges to the table in question in SQL Server AND in ColdFusion ----- Original Message ----- From: "Susan H. Allen" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, January 02, 2003 3:42 PM Subject: Permissions Problem?
> Good morning, > > I have just created a new table in an existing SQL2000 database and wrote CF > code to delete and insert into that table. I am getting this error: "Error > Executing Database Query. Executing the SQL statement is not allowed." The > permissions on this table are the same as all other tables in the database; > I've never gotten such an error before on any other delete/insert statements > in any other database. What is up with that? > > TIA, > > Susan Allen > Pfingsten Publishing, L.L.C. > [EMAIL PROTECTED] > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
