Re: [Firebird-net-provider] Help: Unable to execute the GRANT statement

2007-10-17 Thread Carlos
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 Execute

[Firebird-net-provider] Help: Unable to execute the GRANT statement

2007-10-17 Thread Shanand Chandradas
Hello, I am using FirebirdSql.Data.FirebirdClient.dll in my project. I am trying to execute GRANT statement for a USER to grant a role sat OPERATOR. CODE: fbCmd = New FbCommand() FbCon = New FbConnection(connstring) /* Connection is made to the security.fdb with user SYSDBA and