Home All Groups Group Topic Archive Search About

Security & New Distribution

Author
9 Nov 2006 4:18 PM
LilMorePlease
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

Author
9 Nov 2006 4:42 PM
Keith Wilby
Show quote Hide quote
"LilMorePlease" <LilMorePle***@discussions.microsoft.com> wrote in message
news:5A3537A7-32E7-4D10-B32F-0326F8CF65EA@microsoft.com...
> 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.