Issue Details (XML | Word | Printable)

Key: CORE-4659
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Imam Chalimi
Votes: 0
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Error "Missing security context for .....\SECURITY3.FDB"

Created: 06/Jan/15 09:17 AM   Updated: 18/Jan/16 03:22 PM
Component/s: API / Client Library
Affects Version/s: 3.0 Beta 2
Fix Version/s: 3.0 Beta 2

File Attachments: 1. Zip Archive attach_4659.zip (292 kB)
2. Text File bug_text.txt (0.8 kB)

Image Attachments:

1. bug_pic.jpg
(89 kB)

2. fb_snapshot.jpg
(207 kB)
Environment: Windows 7 32bit
Issue Links:
Relate
 

QA Status: No test


 Description  « Hide
an Error "Missing security context for .....\SECURITY3.FDB" when create new user (create user ...) or select security table (select * from sec$users) on per database user configuration.

This error occurs on firebird 3 snapshot build Firebird-3.0.0.31514-0_Win32 - Firebird-3.0.0.31530-0_Win32 (last today snapshot).
on Firebird-3.0.0.31512-0_Win32 is fine.

** database.conf **
koko = D:\koko\koko_new.fb
{
 SecurityDatabase = koko
}

** script **
C:\fb30.b1>isql /3064:koko -user sysdba -pass masterkey
Database: /3064:koko, User: sysdba
SQL> select * from sec$users;

SEC$USER_NAME SEC$FIRST_NAME SEC$MIDDLE_NAME
                  SEC$LAST_NAME SEC$ACTIVE SEC$ADMIN SEC$DE
SCRIPTION SEC$PLUGIN
=============================== ================================ ===============
================= ================================ ========== ========= ========
========= ===============================
Statement failed, SQLSTATE = 28000
Missing security context for C:\FB30.B1\SECURITY3.FDB
SQL> quit;

C:\fb30.b1>isql /3064:koko -user sysdba -pass masterkey
Database: /3064:koko, User: sysdba
SQL> create user test123 password '123';
Statement failed, SQLSTATE = 28000
Missing security context for C:\FB30.B1\SECURITY3.FDB
SQL>

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Imam Chalimi made changes - 06/Jan/15 09:19 AM
Field Original Value New Value
Security Developers [ 10012 ]
Attachment bug_pic.jpg [ 12659 ]
Attachment bug_text.txt [ 12660 ]
Description an Error "Missing security context for .....\SECURITY3.FDB" when create new user (create user ...) or select security table (select * from sec$users) on per database user configuration.

This error occurs on firebird 3 snapshot build Firebird-3.0.0.31514-0_Win32 - Firebird-3.0.0.31530-0_Win32 (last today snapshot).
on Firebird-3.0.0.31514-0_Win32 is fine.

** database.conf **
koko = D:\koko\koko_new.fb
{
 SecurityDatabase = koko
}

** script **
C:\fb30.b1>isql /3064:koko -user sysdba -pass masterkey
Database: /3064:koko, User: sysdba
SQL> select * from sec$users;

SEC$USER_NAME SEC$FIRST_NAME SEC$MIDDLE_NAME
                  SEC$LAST_NAME SEC$ACTIVE SEC$ADMIN SEC$DE
SCRIPTION SEC$PLUGIN
=============================== ================================ ===============
================= ================================ ========== ========= ========
========= ===============================
Statement failed, SQLSTATE = 28000
Missing security context for C:\FB30.B1\SECURITY3.FDB
SQL> quit;

C:\fb30.b1>isql /3064:koko -user sysdba -pass masterkey
Database: /3064:koko, User: sysdba
SQL> create user test123 password '123';
Statement failed, SQLSTATE = 28000
Missing security context for C:\FB30.B1\SECURITY3.FDB
SQL>
an Error "Missing security context for .....\SECURITY3.FDB" when create new user (create user ...) or select security table (select * from sec$users) on per database user configuration.

This error occurs on firebird 3 snapshot build Firebird-3.0.0.31514-0_Win32 - Firebird-3.0.0.31530-0_Win32 (last today snapshot).
on Firebird-3.0.0.31512-0_Win32 is fine.

** database.conf **
koko = D:\koko\koko_new.fb
{
 SecurityDatabase = koko
}

** script **
C:\fb30.b1>isql /3064:koko -user sysdba -pass masterkey
Database: /3064:koko, User: sysdba
SQL> select * from sec$users;

SEC$USER_NAME SEC$FIRST_NAME SEC$MIDDLE_NAME
                  SEC$LAST_NAME SEC$ACTIVE SEC$ADMIN SEC$DE
SCRIPTION SEC$PLUGIN
=============================== ================================ ===============
================= ================================ ========== ========= ========
========= ===============================
Statement failed, SQLSTATE = 28000
Missing security context for C:\FB30.B1\SECURITY3.FDB
SQL> quit;

C:\fb30.b1>isql /3064:koko -user sysdba -pass masterkey
Database: /3064:koko, User: sysdba
SQL> create user test123 password '123';
Statement failed, SQLSTATE = 28000
Missing security context for C:\FB30.B1\SECURITY3.FDB
SQL>
Imam Chalimi made changes - 09/Jan/15 12:37 AM
Component/s API / Client Library [ 10040 ]
Alexander Peshkov made changes - 12/Jan/15 08:47 AM
Assignee Alexander Peshkov [ alexpeshkoff ]
Imam Chalimi made changes - 12/Jan/15 12:03 PM
Attachment attach_4659.zip [ 12662 ]
Alexander Peshkov made changes - 13/Jan/15 11:37 AM
Fix Version/s 3.0 Beta 2 [ 10586 ]
Affects Version/s 3.0 Beta 2 [ 10586 ]
Affects Version/s 3.0 Beta 1 [ 10332 ]
Imam Chalimi made changes - 13/Jan/15 10:37 PM
Attachment fb_snapshot.jpg [ 12664 ]
Alexander Peshkov made changes - 14/Jan/15 03:39 PM
Link This issue is related to CORE-4607 [ CORE-4607 ]
Alexander Peshkov made changes - 14/Jan/15 03:40 PM
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Pavel Cisar made changes - 23/Sep/15 11:32 AM
Status Resolved [ 5 ] Closed [ 6 ]
Pavel Zotov made changes - 18/Jan/16 03:22 PM
Status Closed [ 6 ] Closed [ 6 ]
QA Status No test