Importing Users From Interbase

[lpk294]

Hi to all the people there...
I have a database in Interbase which i have created a Delphi Front End for.

Now I've created many users in Interbase and set them user rights on the database.

In delphi, I have used TIB components to link to the Interbase database.
The problem arises when I am trying to log on with the differnt users in interbase (using the LOG IN promt from .
For example, if i have set just "SELECT" grants to a certain user and try to log in Delphi with that user, Delphi will not let me as it says the user does not have the other rights.

The only way around this that I have found is to give all rights to the user, which results in successful log in, in Delphi.
However, the purpose of "User Rights" is then defeated if I have to give all privelages to a user so that he can log in, in Delphi.

Is there any way I can log in with the user rights I have set?

Thanks a lot guys, I hope someone has a solution to this problem.

 

[svanels]

The user rights are set at Interbase level. Delphi itself uses the username provided when connecting to Interbase.

In your application you have to define which user gets which form query or table.

If the user have only select granted, opening a table with the modification option will result in blockage at the server when trying to save. I would suggest to use queries when using interbase. I only use ttables for short tables for super users.

The only way to go is carefully rethink your application, examine who are normal users, super users and administrators.
Design your forms knowing in mind which user is going to use that form.

Steven van Els
SAvanEls@cq-link.sr