RE: SQL on grant all

2002-03-12 Thread Pascal Peters
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:

Re: SQL on grant all

2002-03-12 Thread Stephen Moretti
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

Re: SQL on grant all

2002-03-12 Thread Mak Wing Lok
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

RE: SQL on grant all

2002-03-12 Thread Mak Wing Lok
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