Modifying user via Services API without modifying a password

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
upscene
Posts: 306
Joined: Thu 19 Oct 2006 08:13

Modifying user via Services API without modifying a password

Post by upscene » Thu 28 Jan 2010 13:51

Hi,

Is it possible to modify the properties of a user WITHOUT modifying its password?

In IBX, I simply did not set the password to anything and it would stay unmodified, how can I do this with IBDAC?

With regards,

Martijn Tonies

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Thu 28 Jan 2010 13:59

The same way can be used with IBDAC.

If you does not assign a value to a property, it stays unmodified.

upscene
Posts: 306
Joined: Thu 19 Oct 2006 08:13

Post by upscene » Thu 28 Jan 2010 14:05

Well, it gets modified :)

But I'm explicitly setting it to '' first, I guess I shouldn't do that then?

That being said, is the "change" checked after each call to .ModifyUser ot so?

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Mon 01 Feb 2010 12:06

We have tested TIBCSecurityService on Firebird with the following sample:

Code: Select all

  IBCSecurityService1.Username := 'SYSDBA';
  IBCSecurityService1.Password := 'masterkey';
  IBCSecurityService1.Active := True;

  IBCSecurityService1.UserInfo.UserName := 'SYSDBA';
  IBCSecurityService1.UserInfo.FirstName := 'Test';
  IBCSecurityService1.ModifyUser;
In this case the password stays unmodified. Please check that you did not modify the user property.

upscene
Posts: 306
Joined: Thu 19 Oct 2006 08:13

Post by upscene » Mon 01 Feb 2010 12:12

Challenger wrote:We have tested TIBCSecurityService on Firebird with the following sample:

Code: Select all

  IBCSecurityService1.Username := 'SYSDBA';
  IBCSecurityService1.Password := 'masterkey';
  IBCSecurityService1.Active := True;

  IBCSecurityService1.UserInfo.UserName := 'SYSDBA';
  IBCSecurityService1.UserInfo.FirstName := 'Test';
  IBCSecurityService1.ModifyUser;
In this case the password stays unmodified. Please check that you did not modify the user property.
As I said, I was setting it to '' (empty string), this seems to trigger the change.

Is the "property changed" flag reset after calling .ModifyUser?

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Tue 02 Feb 2010 08:32

Is the "property changed" flag reset after calling .ModifyUser?
Yes

Post Reply