Table PLG$USERS and view PLG$VIEW_USERS are not created automatically when you
create a SYSDBA with Legacy_UserManager
----------------------------------------------------------------------------------------------------------------------
Key: CORE-4969
URL: http://tracker.firebirdsql.org/browse/CORE-4969
Project: Firebird Core
Issue Type: Bug
Components: Security
Affects Versions: 3.0 Beta 2
Environment: Windows 7 x64, Firebird 3.0.0.32060 x64
Reporter: Simonov Denis
Create database with standard Security Database. Then assign it as the Security
Database itself.
test = d:\fb\fb30\data\test.fdb
{
DefaultDbCachePages = 8K
TempCacheLimit = 512M
SecurityDatabase = test
WireCrypt = Enabled
AuthServer = Legacy_Auth
UserManager = Legacy_UserManager
}
And we are trying to initialize the SYSDBA.
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect test user sysdba;
Database: test, User: SYSDBA
SQL> create user sysdba password 'masterkey';
Statement failed, SQLSTATE = 42S02
add record error
-table PLG$VIEW_USERS is not defined
SQL>
OK. Change configuration
test = d:\fb\fb30\data\test.fdb
{
DefaultDbCachePages = 8K
TempCacheLimit = 512M
SecurityDatabase = test
WireCrypt = Enabled
AuthServer = Srp, Legacy_Auth
UserManager = Srp, Legacy_UserManager
}
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect test user sysdba;
Database: test, User: SYSDBA
SQL> create user sysdba password 'masterkey';
SQL> exit;
Trying to connect
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 'localhost:test' user sysdba password 'masterkey';
Database: 'localhost:test', User: SYSDBA
SQL> set list on;
SQL> select * from sec$users;
Statement failed, SQLSTATE = 42S02
find/display record error
-table PLG$VIEW_USERS is not defined
SQL>
Apparently table PLG$USERS and view PLG$VIEW_USERS are predefined in
security3.fdb, but are not automatically created when initializing sysdba with
Legacy_UserManager.
In addition, we have a side effect - the unavailability SEC$USERS.
--
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
