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

[sahadasht]

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!

[zmbd]

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: https://en.wikipedia.org/wiki/Compar...gement_systems

[zmbd]

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!<

Hello
Is it possible to separate the description for each item?
I need to have quick access to information.
Thank You

@sahadasht:
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...

-Z

><

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

Sahadasht,
Once again, you must ask your questions in the public forums.
This is a SITE POLICY
https://bytes.com/faq.php?faq=how_to_ask_a_question

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.
https://support.office.com/en-us/art...b-b5f5cfa9a766

As for the remainder of your questions:
ACCESS IS NOT A SECURE DATABASE - period.
There are no verification and deductibility etc...
Encryption is not supported in the tables unless you roll your own such as:
https://bytes.com/topic/access/insig...m-vba-vbscript
and store the result...

All of this information is easily found with a few Google/DuckDuckGo searches.
-z

><

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
...

[Rabbit]

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.

[PhilOfWalton]

Looks like a college homework question to me.

Phil

[zmbd]

Closing thread as "Asked and Answered"