SQL Server AUTH

[zezo2021]

friends

If I have an online SQL server Db

and I have 10 users for example

Should I create one user for all these users and they all login by this username and password

or create for every user ( username and password)

 

[GPGeorge]

Probably not. There's more to SQL Server security than there is to Access security. This presentation from a year ago covers a lot of this important ground.

 

[Neros]

I used to set 3 users on SQL database:

• adm: can create/alter tables, views, procedures, etc
• write: can insert and update tables inside the database, as well as execute procedures that will change data
• read: can only run queries or execute procedures that will return data - created most for running reports or dashboards
• task: internal user specifically to run automated tasks (like backups, SSIS packages or run procedures)

From this list, only write and read are listed on Access front-end.

To track user activity, I have a log procedure fired after record saving. This procedure save user, date/time, form name, field name, old and new value.

For your scenario, I think you can log activity on a local table and submit to online table on logout.