hello!

i am developing a win32 application that uses
FB-embedded version v2.0.1

that application is a program that only let users
to make "complex" SELECTs to the database
(there are no inserts, updates or deletes)

the data of the database is currently being stored
using "SYSDBA/masterkey".

since this application will be delivered to different
clients, people who is storing data (confidential) are
afraid of being stolen. (i mean, anyone can open the
database and extract the information)

unaffortunately i didnt find how to encrypt FB record,
it cant be done, rigth ?

so, how can i protect the records ?

after storing the data, do i have to delete sysdba
username ?

do i have to set tables to be only accesible by
another user ?

may i change the user who has access to the records
after storing then with sysdba ?

will the new configuration remain using embedded
version of FB ?

to create the database i exec this script:

CREATE DATABASE 'C:\test.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE = 4096
DEFAULT CHARACTER SET ISO8859_1;

connect 'C:\test.fdb'
USER 'SYSDBA' PASSWORD 'masterkey';

CREATE TABLE NEW_TABLE1 (
FIELD1 SMALLINT NOT NULL
);

ALTER TABLE NEW_TABLE1 ADD PRIMARY KEY (FIELD1);

then i store houndred of records.

is this ok ? or i have to create the database
using another dba ?

i want that record not to be accessible to anybody
instead of somebody that has the correct password
(i mean, also if he copies the db file into another
computer)

thanks in advance,
j.-





__________________________________________________
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya!
http://www.yahoo.com.ar/respuestas