[Firebird-devel] [FB-Tracker] Created: (CORE-4969) Table PLG$USERS and view PLG$VIEW_USERS are not created automatically when you create a SYSDBA with Legacy_UserManager

[Simonov D. (JIRA) <tr...@fi...>]

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