[#CORE-1972] Non-SYSDBA user can change FW mode of database.

Firebird Core

Non-SYSDBA user can change FW mode of database.

Created: 02/Jul/08 06:03 AM Updated: 26/Jan/09 09:17 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

Time Tracking:

Not Specified

Environment:

independent

Target:	2.5 Beta 1, 2.1.2 and 2.0.5
Planning Status:	Unspecified

Description

« Hide

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

All

Comments

Work Log

Change History

Version Control

FishEye

Sort Order:

[ Permalink | « Hide ]

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.