Hello, cedriz!

Monday, March 25, 2013, 10:37:24 AM, you wrote:

cm> im sorry for not elaborating my question and stating it clearly.
cm> restrictions means restrictions on accessing files, e.g. on my
cm> database i have 5 tables in which only 2 tables will be allowed on
cm> a account or 3 tables.

read about SQL GRANT/REVOKE.
When you create user, it does not have any permissions,
you need to GRANT something (at least select) for user to be
able read data from some table.

cm> i would like to know if it will be on
cm> delphi 7 that i put the restriction or will it be on the firebird
cm> server?

GRANT/REVOKE is an SQL commands. They applied to the database,
i.e. enforced by Firebird. But, as any SQL commands grant/revoke
can be executed from Delphi, or any other tool.

"In Delphi" you need to specify only user name at login to the
database to get these restrictions.

cm> i want to set up a network in which i can connect on a
cm> local network and at the same time can access it remotely from
cm> another location. not included in the local network.

This does not related to the questions above.
TCP is TCP, local or "remote", there is no difference
in tcpv4 between LAN and "internet".
When user connects to the database, GRANTs applied
with no care where this user "came from".

--
Dmitry Kuzmenko, www.ib-aid.com