By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,320 Members | 1,893 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,320 IT Pros & Developers. It's quick & easy.

Requests for help on access control and encryption capabilities in the Access databas

P: 1
The existence or non-existence of the following in an Access database and how it is implemented, if any:

1-Supported Mandatory Policies?
2-Authorized negative?
3-Access control with regard to time and space constraints?
4-Recovery Non-Cascading Permissions?
5-Recover Cascading Permissions?
6-Supports separation of tasks?
7-Optional policy support?
8-What is the use of roles in ms access?
9-manage user access in ms access?
10-Supports hierarchy of roles?
11-Supports separation of tasks?

12-The database cipher is transparent to the user's perspective?

13-Cryptographic scale on base components?

14-Verification and deductibility mechanism?

15-Indication on encrypted column?

16-Encryption algorithms supported in Access?

How about the above
Access supported?

Thank You

Hello to you
Thank you for asking me publicly.
I asked my question publicly, but it was not inserted. For this, I had to edit the first question in order to insert a second question. Or to privately ask you!
Jul 10 '18 #1
Share this Question
Share on Google+
5 Replies

Expert Mod 5K+
P: 5,397
For the most part: None of the above.
Access is not a full-blooded SQL database such as Oracle, SQL Server, MySQL, MariaDB, etc... if you want threading, access control, roles, etc... then you need to look at another database engine. You might start here - the article is a bit old but should have a good starting point for your reasearch:
Jul 11 '18 #2

Expert Mod 5K+
P: 5,397
sahadasht has asked me a series of questions via PM
Due to the nature of the questions I've forwarded them here to the public forum. Perhaps others will have more information, or perhaps a better explanation, than I do about what Sahadasht is asking.

> Please keep in mind, it is normally against site policy to PM questions or replies unless the information is of a confidential nature, an expert or a moderator has made the request, and the Member doing so must carefully consider the ramifications of disclosing information to someone they've never met face-to-face!<

Is it possible to separate the description for each item?
I need to have quick access to information.
Thank You
Please take note: Site policy typically requires all responses/questions be posted publicly in the thread.

HOWEVER in this case - it doesn't matter because the answer to your question is that Access doesn't natively support any of the parameters you are asking about - period.

If you need user roles etc... you have to develop them yourself (and they can all be bypassed in such case by any knowledgeable user) or use a full fledged database such as Oracle, etc...

The database cipher is transparent to the user's perspective?

Cryptographic scale on base components?

Verification and deductibility mechanism?

Indication on encrypted column?

Encryption algorithms supported in Access?

How about the above
Access supported?

Thank You
Once again, you must ask your questions in the public forums.

As with any encryption, once a database is encrypted in Access, it's not available to they user without the password. The cryptographic provider is through windows and depends upon what is available. For Access2010 and beyond AES is the standard unless backwards compatibility is required.

As for the remainder of your questions:
There are no verification and deductibility etc...
Encryption is not supported in the tables unless you roll your own such as:
and store the result...

All of this information is easily found with a few Google/DuckDuckGo searches.
I have to give a seminar and have a little time and I have to answer all these questions in full. So I ask the inverter.

Can you have more companions in answering questions?
And that is exactly why you should ask the questions in the public forum and not the private messaging system

As for your seminar... you're sunk as far as Access is concerned, it simply doesn't do anything you've asked about - IT IS NOT A SECURE DATABASE nor was it ever intended to be a secure database.

If you need further answers, you must ask your questions in the public forum
Jul 11 '18 #3

Expert Mod 10K+
P: 12,366
90% of your questions can't be answered because I have no idea what they're asking. Take #1 for example, "mandatory policies". I have no idea what you mean by policy, that's such a generic term that has many meanings.

Most of the answers to your questions will be no, that is not implemented in Access. And even if you could replicate it through VBA code, it's fairly trivial to get around by a motivated individual.
Jul 11 '18 #4

Expert 100+
P: 1,430
Looks like a college homework question to me.

Jul 11 '18 #5

Expert Mod 5K+
P: 5,397
Closing thread as "Asked and Answered"
Jul 12 '18 #6

This discussion thread is closed

Replies have been disabled for this discussion.