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
There are no subversion log entries for this issue yet.