Issue Details (XML | Word | Printable)

Key: CORE-1972
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Alexander Peshkov
Votes: 0
Watchers: 1

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

Non-SYSDBA user can change FW mode of database.

Created: 02/Jul/08 06:03 AM   Updated: 09/Mar/18 08:51 AM
Component/s: None
Affects Version/s: 1.0.3, 2.0.0, 1.5.4, 2.0.1, 2.1 Alpha 1, 2.1 Beta 1, 2.0.2, 2.0.3, 2.1 Beta 2, 1.5.5, 2.1 RC1, 2.5 Initial, 2.1 RC2, 2.1.0, 2.0.4, 2.5 Alpha 1, 2.1.1
Fix Version/s: 2.0.5, 2.1.2, 2.5 Beta 1, 1.5.6

Environment: independent

Target: 2.5 Beta 1, 2.1.2 and 2.0.5
QA Status: Done successfully

 Description  « Hide
Non-SYSDBA user can change FW mode of database just adding appropriate parameter to DPB when attaching to it.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Peshkov added a comment - 07/Jul/08 08:14 AM
Except force write setting, access is also limited (admin and DBO only) to the following list of dpb options: dpb_set_db_readonly, dpb_set_db_sql_dialect, dpb_sweep_interval and dpb_no_reserve. Use of dpb_set_page_buffers differs in classic and super servers. In case of SS it's completely disabled for non-admin connections. In case of CS one can set size of buffers per connection, but settings in database remain not modified.