COMMENT ON USER can only apply comment on user defined by the default
usermanager plugin
----------------------------------------------------------------------------------------
Key: CORE-6479
URL: http://tracker.firebirdsql.org/browse/CORE-6479
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.7, 4.0 Beta 2
Reporter: Mark Rotteveel
The COMMENT ON USER statement can only put comments on users of the default
usermanager. The syntax should be extended to include an optional USING PLUGIN
<pluginname> clause. For example `COMMENT ON USER x USING PLUGIN pluginname IS
'comment'`
With setting UserManager = Srp,Legacy_UserManager.
create user test1 password 'test1' using plugin srp;
create user test2 password 'test2' using plugin legacy_usermanager;
commit;
The following will succeed:
comment on user test1 is 'comment on user test1';
The following will fail:
comment on user test2 is `comment on user test2';
[336723990] [HY000]: Resource Exception. record not found for user: TEST2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
