Security & New Distribution

[Guest]

I've redesigned a database, properly normalizing it from 1 table to 8 tables.
I've spent a full month on this, building a full fledged application with
custom functions and the whole nine yards. The company I am working for is
actually closing down their office and relocating across the nation, and the
new database is going along with the move. I won't be here to see the
database being implemented at the new location, as I am leaving the company
to start a new job.

What can I do to maximize security so that the program doesn't "break"
during the process of implementing it at the new location. There will be one
or two people who will be using the database (entering data, running reports
etc). I am wondering if it's a good idea to set up user accounts when I
don't know any facts about who is going to be using the application (it
hasn't even been determined yet).

Ideas and suggestions are greatly appreciated!

AA

 

[Keith Wilby]

I've redesigned a database, properly normalizing it from 1 table to 8
tables.
I've spent a full month on this, building a full fledged application with
custom functions and the whole nine yards. The company I am working for
is
actually closing down their office and relocating across the nation, and
the
new database is going along with the move. I won't be here to see the
database being implemented at the new location, as I am leaving the
company
to start a new job.

What can I do to maximize security so that the program doesn't "break"
during the process of implementing it at the new location. There will be
one
or two people who will be using the database (entering data, running
reports
etc). I am wondering if it's a good idea to set up user accounts when I
don't know any facts about who is going to be using the application (it
hasn't even been determined yet).

Ideas and suggestions are greatly appreciated!

AA

Until you know which accounts need access to what data, the best you can do
IMO is provide two accounts, a guest read-only account and a full data
access account. Oh, and an admin account of course!

Regards,
Keith.