----- Original Message -----
From: "Alan McDonald" <alan@...>
Sent: Friday, August 15, 2008 9:15 PM
>> Thanks Alan, can I ask a few questions on what you said...
>> What program would I use to take the backup and create a new copy of
>> the database with the new owner?
>
> gbak
I think I'm making a little progress on this.
- I created a new user using the IB_SQL tool.
- I then used gbak to make a backup of the database.
- I then used gbak to restore the database, but I used the new user I had
created to do this.
However, when I run my Delphi application and try to access the database, I
get the following error:
"Project myproject.exe raised exception class EIBInterBaseRoleError with
message 'no permission for read/select access to TABLE mytable'. Process
stopped. Use Step or Run to continue."
Even though my new user is the owner, I don't have sufficient rights to
access the tables. How can I grant these rights to my new user?
I'm also interested in knowing what others do when deploying applications
using Firebird.
1) Do you send them a link to the Firebird install file to enable them to
install it or do you include it as part of your install?
2) Do you connect to the database using sysdba / masterkey, or do you
connect using a new owner user you created?
3) How do you get the end-user to create the Firebird username/password
required to access the database?
4) Do you ask the user to enter the username/password each time they run the
application, or do you store them somewhere, or do you hardcode them in your
application?
This is assuming the end-user is not necessarily tech-savvy and your
application may or may not be on the same computer as your database. In my
case my application will be available for download as a demo, so anyone
could be trying it out.