MS Access Database is one
of the most popular Database Management System used to manage and
maintain large quantity of data. It is considered as most flexible
and the simplest database management system as compared with other
Database management system. It is preferred by most of the Microsoft
User because of its 'Windows look and feel' and also for its
compatibility with other Microsoft products.
Every database stores all
type of data including sensitive and confidential data. So it is
necessary to manage the proper security of your database to prevent
from unauthorized access. MS Access also provides some security
features so that data can be accessed by authorized user only. One of
such security feature is setting user level permission. User
permissions allow database administrator to assign different role to
different user according to their requirement. In MS access there are
nine types of permission which can be assigned to a user (or a group
of user). These nine types of permission and associated roles are
listed below.
1. Open - Allows user to open a
database, report or form.
2. Open Exclusive - It allows a
user to open a database exclusively (other user can not open the
database simultaneously).
3. Read Design - It allows user
to read/view object design (user can not change the design).
4. Modify Design - It allows
user to view, change (or delete) objects.
5. Administer - This type of
access have full access to the database and objects. With this
permission user can set password to database and assign permission to
other user.
6. Data Read - User can view
data but cannot edit it (user cannot view design of tables and
queries).
8. Insert Data - User can view
and insert data but not allowed to delete or change data.
9. Delete Data - User can view
or delete data but cannot change or insert data.
It should be noted that before using
above mentioned user permissions you should have a clear view about
the task of every employee who interacts with the database. For
example ‘Data Read’ permission can be allowed to ‘Data Analyst’
user (because he needs to view data only), ‘Insert Data’ can be
assigned to user who is responsible for adding new data to the
database.
If you are the only user
of database then it is not a good idea to use any of the user
permission to protect database. In such case you can set password to
the main database file (MDB or ACCDB file) so that other user can not
access database without your permission. Setting password to the MDB
or ACCDB file is considered as the easiest method but you can fall in
problem if you forget (which is common human nature) the password of
your access database. In case you forget your MDB file password then
you can use Access Password Recovery Software to recover password of
access database. Such software provides easiest way to recover
password of MS Access database file.
No comments:
Post a Comment