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 password masterkey
fbCmd.Connection = FbCon
fbCmd.Connection.Open()
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
MsgBox("DONE")
End If
fbCmd.Transaction.Commit()
The above code executes without any exception, but the execution grant
statement has no effect. I verified whether the user TESTUSER
Has obtained the correct privilege by searching for that record: select
* from RDB$USER_PRIVILEGES where RDB$USER="TESTUSER"
How do I successfully execute GRANT Statement?
Regards,
Shanand Chandradas
Software Engineer | KPIT Cummins Infosystems Ltd.| Ext No.5294 | Mob:
9970053521
-------------------------------------------------------------------------
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
