I'm using Delphi 10.3.3 and Firebird embedded 3.x in an application for the first time, I'd created the fdb file on my server and then copied it to the computer / directory where I'm developing the application that will make use of the database. I'm able to connect without any problem but when I attempt to execute a SQL Delete statement to clear records from a table in order to repopulate it I get this error "EIBNativeException with message [FireDac][Phys][FB]no permission for DELETE access to TABLE MUSIC". From what research I was able to do this was the information I found "The user name specified during the "logon" (no password authentication occurs) is used to manage user access to database objects (via SQL permissions) but if that user name is SYSDBA (or the owner of the database) then unrestricted access is possible" and the user that I'm connecting with is SYSDBA. So I'm puzzled about why I'm getting a permissions error when I'm attaching as SYSDBA, ideas's?
[firebird-support] Firebird Embedded access permissions problem?
'Chris LeFebvre' lefebv...@comcast.net [firebird-support] Tue, 18 Feb 2020 17:08:00 -0800
- [firebird-suppor... 'Chris LeFebvre' lefebv...@comcast.net [firebird-support]
- [firebird-s... Norbert Saint Georges n...@tetrasys.eu [firebird-support]