1

Topic: FB 3.0 it is impossible to activate the user

Kind time of days all;
The user already  in basis
From under SYSDBA I give
ALTER USER MIK ACTIVE
Commit transits without an error and status SEC$ACTIVE  remains null
In what there can be a reason?
Can explicitly specify at creation of the user SEC$PLUGIN
Now at the new user :
SEC$PLUGIN = ' Legacy_UserManager'
And at SYSDBA:
SYSDBA = ' Srp'
But change on:
ALTER USER MIK SET ACTIVE USING PLUGIN Srp
Commit  too without an error and SEC$ACTIVE remains null
Thanks

2

Re: FB 3.0 it is impossible to activate the user

Mikhail Tchervonenko;
So it at you and so the active. What to change that you try? Here if you at first deliver it INACTIVE, and then ACTIVE will see a difference.
And if I am not mistaken in Legacy_UserManager Active/Inactive is not supported

3

Re: FB 3.0 it is impossible to activate the user

Simonov Denis;
Simply I see a field which on my concept should be not null. But if does not support then . I will be  with Srp

4

Re: FB 3.0 it is impossible to activate the user

Simonov Denis;
The question in , and what for SYSDBA exists under  plug-ins?

5

Re: FB 3.0 it is impossible to activate the user

Mikhail Tchervonenko;
Well and how by the client 2.5 it will be connected SYSDBA? In any way. Legacy and Srp is a different enciphering of the password. And the password will not be deciphered, it is compared. The client ciphers it what can - 2.5 DES, 3.0 - DES or MD5. Further the server only ciphers the password the same algorithm, and compares result that in basis.

6

Re: FB 3.0 it is impossible to activate the user

kdv;
And why COMMENT ON USER MIK IS ' Test comment'
Does not see the active user created of under Srp?
"Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
record not found for user: MIK."
Also there is a question and what plug-in it is necessary to use in 3 from the point of view of perspectives on ?

7

Re: FB 3.0 it is impossible to activate the user

Mikhail Tchervonenko;
Srp

8

Re: FB 3.0 it is impossible to activate the user

Mikhail Tchervonenko wrote:

also there is a question and what plug-in it is necessary to use in 3 from the point of view of perspectives on ?

Question senseless inherently. Because plug-in Legacy is intended for operation with old clients (2.5), and word Legacy in itself designates "a heritage, the inheritance", i.e. something already become outdated.
What future at Legacy, , can be? Only obsolete, deprecated and further :-)