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-suppor... 'Chris LeFebvre' lefebv...@comcast.net [firebird-support]
    • [firebird-s... Norbert Saint Georges n...@tetrasys.eu [firebird-support]

Reply via email to