I am having trouble figuring out the EDB security settings. In DBISAM
I would just encrypt certain sensitive tables. However with EDB I
would settle with setting up a database so that in order to connect to
it or open it with the DB Manager you need to supply a username and
password. Like what you have to do in bigger DBs like MS SQL Server.
Ideally it would start out wide open but if the user wanted to they
could setup a username and password. So how would you go about this?
You can seem to do this in the EDB Manager software.

Michael,

<< I am having trouble figuring out the EDB security settings. In DBISAM I
would just encrypt certain sensitive tables. However with EDB I would settle
with setting up a database so that in order to connect to it or open it with
the DB Manager you need to supply a username and password. Like what you
have to do in bigger DBs like MS SQL Server.  Ideally it would start out
wide open but if the user wanted to they could setup a username and
password. So how would you go about this? >>

Well, to use the default Administrator login, you don't have to do anything.
After that point, how complicated the user security scheme is really depends
upon how far you want to take things.  You can create roles, assign
privileges for the tables, etc. to these roles, and then grant these roles
to users as they are created, or you can just grant each individual user the
desired privileges to the various database objects in the database.  Did you
read this section of the manual yet ?

http://www.elevatesoft.com/edb1sql_user_security.htm

--
Tim Young
Elevate Software
www.elevatesoft.com