C
casey
I am in the process of developing an app using DAP but have never
implemented security model. This will be the first time.
I have downloaded the Security FAQ from Microsoft but unsure if this will
help my situation.
What I need:
1) track who made the change on the form and log that into the tables
(similar to an audit trail). There is no need to prompt the user for a
login and password (this is ideal). Is it possible to capture their network
login instead and use that? The OS on each user workstation varies from
Win2000 and WinXP.
2) if the prompt for login and password is disabled, this mean anybody who
have access to the .adp file can manipulate the data (even if knowingly or
unknowingly their login is being captured). is my assessment right?
3) can I query who is currently using the ADP file?
4) what are the disadvantage if step1 is applied in terms of sql server
security? do I need to create a standard login in sql server for this
application to work?
If I missed anything, let me know. Any advise is appreciated.
TIA!
Bob
implemented security model. This will be the first time.
I have downloaded the Security FAQ from Microsoft but unsure if this will
help my situation.
What I need:
1) track who made the change on the form and log that into the tables
(similar to an audit trail). There is no need to prompt the user for a
login and password (this is ideal). Is it possible to capture their network
login instead and use that? The OS on each user workstation varies from
Win2000 and WinXP.
2) if the prompt for login and password is disabled, this mean anybody who
have access to the .adp file can manipulate the data (even if knowingly or
unknowingly their login is being captured). is my assessment right?
3) can I query who is currently using the ADP file?
4) what are the disadvantage if step1 is applied in terms of sql server
security? do I need to create a standard login in sql server for this
application to work?
If I missed anything, let me know. Any advise is appreciated.
TIA!
Bob