Hi,
Thanks for the reply.
What I need to achieve is to set roles to the user using GRANT statement.
With the code I had given to you, I could not see any success.
I used fbcommand for executing the grant statement.
It just returns -1. The return value doesn't bother me..
I need to know the way for executing the GRANT. However I don't get any
exception.
Dim fbCmd As FbCommand
fbCmd = New FbCommand()
FbCon = New FbConnection(connstring) /* connection to security.fdb/*
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 /* No success
MsgBox("DONE")
End If
fbCmd.Transaction.Commit()
Please help me out a way for executing the grant statement for a user
Thanks & 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 Jiri Cincura
Sent: Thursday, October 18, 2007 12:19 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Help: Unable to execute theGRANTstatement
On 10/17/07, Shanand Chandradas <[EMAIL PROTECTED]> wrote:
> 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.
>
AFAIK if it's not successful, you¨ll get exception.
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-------------------------------------------------------------------------
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
