Unable to set FName, MName, LName fields in security to blank [CORE856]

[firebird-automations]

Submitted by: Alan McDonald (alanmcd)

Is related to QA158

Once fields FirstName, MiddleName, LastName are set to non blank entries, they cannot be changed to blank entries (i.e. zero length strings).
GSEC does not accept spaces regardless of delimeter attempted: result is the delimeters are used to replace the entries.
Using the Service Manager a space must be used to "blank" out an entry but the entry can never be a zero length string unless the user account is deleted and recreated without the field value being set.

Commits: 4e5adaf

[firebird-automations]

Modified by: @dyemanov

assignee: Alexander Peshkov [ alexpeshkoff ]

[firebird-automations]

Commented by: @AlexPeshkoff

To set each name to empty string, simply do not specify it:
gsec -mod user -fname -mname -lname

But there really was a bug when calling services from gsec. And what about IBOADMIN & IBExpert - please contact developers of this programs to make them be able set length of service parameter to 0.

[firebird-automations]

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.1 Beta 1 [ 10141 ]

[firebird-automations]

Commented by: @pcisar

I have verified this with 2.0.1 and my finding are:
- It's really not possible to blank these fields in GSEC. Using gsec -mod user -fname -mname -lname as Alex suggests does nothing.
- It works via services API. I have used KInterbasDB that correctly handles empty strings to clear these fields. So the problem is in connectivity components used to call services API, not in services API itself.

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA158 [ QA158 ]

[firebird-automations]

Commented by: @pcisar

Fix in GSEC verified for 2.1 Beta 1, test added.

[firebird-automations]

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Modified by: @pcisar

Workflow: jira [ 11076 ] => Firebird [ 14664 ]

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test

[firebird-automations]

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: No test => Done successfully