Hello Carlos, So when -1 is returned, the statement is supposed to be successfully executed? If that is the case, then I am confused. Because it is returning -1, however, the right is not actually allocated to the user in the database.
Is there any other/ proper way for executing the GRANT statement? What I need to achieve is setting of roles to a user using GRANT operation. Any ideas? Regards, Shanand Chandradas Software Engineer | KPIT Cummins Infosystems Ltd.| Ext No.5294 | Mob: 9970053521 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carlos Sent: Wednesday, October 17, 2007 8:04 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Help: Unable to execute the GRANTstatement Hello: > fbCmd.CommandText = "GRANT OPERATOR TO TESTUSER" > > fbCmd.CommandType = CommandType.Text > > fbCmd.Transaction = FbCon.BeginTransaction > > If fbCmd.ExecuteNonQuery() <> -1 Then /*This doesn't return any > value, it only returns -1 ExecuteNonQuery should return the number of rows affected by an insert, update or delete statement or -1 in any other case, so what do you expect a GRANT statement to be returning ?? -- Carlos Guzmán Álvarez Vigo-Spain Blog : http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
