Not that I have a problem, I'm just trying to figure out how things work.
Scenario:
Active Directory with a Windows Server 2016 machine as the Domain Controller
Sql Server Express 2019. Authentication is set to mixed mode.
Clients : Windows 11, 10
Access database FE has linked tables to sql server using Windows Authentication.
With this situation, if anyone from a client PC in active directory create an empty database, s/he can import linked tables from sql server and do whatever s/he wants with the data.
Is this normal? Is there anything that can be done to prevent unauthorized access to the tables?
Thank you.
Scenario:
Active Directory with a Windows Server 2016 machine as the Domain Controller
Sql Server Express 2019. Authentication is set to mixed mode.
Clients : Windows 11, 10
Access database FE has linked tables to sql server using Windows Authentication.
With this situation, if anyone from a client PC in active directory create an empty database, s/he can import linked tables from sql server and do whatever s/he wants with the data.
Is this normal? Is there anything that can be done to prevent unauthorized access to the tables?
Thank you.
Last edited: