This buggy behavior only appears with LO 5.3.0.0.alpha0, because it is the special behavior with the new internal Firebird-database 3.0, which is introduced with LO 5.3: Create a new Firebird-database. Create a table with GUI ( would also work with direct SQL with CREATE TABLE "Table1" ("ID" INTEGER NOT NULL,"Name" VARCHAR(100), PRIMARY KEY ("ID")) ) Save the table. You could also create more tables - is possible at this time. You could also create queries, views ... Now close the database. Reopen the database. Try to create a new table or view: You are not allowed. "There is no privilege for this operation"
On pc Debian x86-64 with master sources updated today, I could reproduce this. I noticed this on console: warn:connectivity.firebird:736:1:connectivity/source/drivers/firebird/Statement.cxx:126: isc_dsql_execute failed warn:connectivity.firebird:736:1:connectivity/source/drivers/firebird/Util.cxx:52: firebird_sdbc error: *unsuccessful metadata update *CREATE TABLE Tasks2 failed *There is no privilege for this operation caused by 'CREATE TABLE "Tasks2" ("ID" INTEGER NOT NULL,"TaskID" INTEGER, PRIMARY KEY ("ID"))' Lionel/Tamas: one for you?
Confirming also on Ubuntu 16.04, with LOdev530 my own master build from 24/10/2016 I see the same error message as Julien, but this is also displayed in the UI by clicking on the "More" button of the UI displayed error message.
I would increase the priority of this bug, as it currently means that a user has to design/create all of their tables on first creation of the ODB file, which is a pretty big limitation in terms of user functionality.
Wastack committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=41832d27c3325808333c21b9181db84ae9788978 tdf#103373 create and connect with default user It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Could confirm the bug is fixed. Created a table in an existing Firebird database, could also add fields later. Tested with Version: 5.3.0.0.alpha1+ Build ID: 5d39c2013374727b1c8f147b8b99d54402a7ff02 CPU Threads: 4; OS Version: Linux 4.1; UI Render: default; VCL: gtk2; Layout Engine: old; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-11-02_00:55:24 Locale: de-DE (de_DE.UTF-8); Calc: group