RE: SQL on grant all
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
Re: 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. You should be able to. What's the error you get? Stephen __ Get Your Own 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=coldfusionb 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
Re: SQL on grant all
i get the error below : Error Diagnostic Information Sybase Error Code = 0 No message generated --- Stephen Moretti [EMAIL PROTECTED] wrote: 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. You should be able to. What's the error you get? Stephen __ 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
RE: SQL on grant all
i'm login as a sa and still get this error : Error Diagnostic Information Sybase Error Code = 0 No message generated --- Pascal Peters [EMAIL PROTECTED] wrote: 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