SQL Database Login Security
L
Lukas Stuefer
It would be nice if you had the option of using Active Directory users to access the SQL database instead of the Local ones. It would also be great to not give the database user the db_owner role. Instead, you should be able to use the DDL_admin role.
We have 2 customers with the wish to implement this by the end of the year.
Best Regards
Lukas
L
Lukas Stuefer
Hi James McNab, in this case yes.
I would guess the AD User Logon, but it is both for their security measurements. Just for the Userrole, maybe it is already working, as the new dll_admin has almost the same rights as the db_owner. So that would be just something to check on an Test environment.
Best Regards
Lukas
James McNab
Lukas Stuefer I think this is two seperate requests:
- Ability to use AD users to access the SQL database
- Ability to use a SQL Server user with the db_ddladmin database role, instead of db_owner role.
For the 2 interested customers, which of these are most important?