Make sure the user for the connection has the right permissions and that the "Restrict SQL Operations to" checkboxes for the datasource in the CF administrator are all unchecked
Pascal -----Original Message----- From: Mak Wing Lok [mailto:[EMAIL PROTECTED]] Sent: dinsdag 12 maart 2002 12:30 To: CF-Talk Subject: SQL on grant all is it possible i run the SQL statement below in <cfquery>? grant all privileges on table1 to user1 i get an error when i do so. __________________________________________________ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists