During the interview I always like to ask below security questions to DBA. I found that sometimes DBAs are not able to answer these questions.
Question 1: What will you do if you lost rights of your SQL Server instance?
We can use the below options
- Dedicated Administrator Connection
- BUILIN\Administrator Group (Incase its rights are not revoked)
- Final Option is to change the registry value
- You can change authentication mode via registry
Question 2: – What is SQL Injection?
SQL Injection is developed where unhandled\unexpected SQL commands are passed to SQL Server in a malicious manner. It is a problem because unknowingly data can be stolen, deleted, updated, inserted or corrupted.
Question 3: – What is the Guest user account in SQL Server? What login is it mapped to it?
The Guest user account is created by default in all databases and is used when explicit permissions are not granted to access an object. It is not mapped directly to any login, but can be used by any login. Depending on your security needs, it may make sense to drop the Guest user account, in all databases except Master and TempDB
Question 4: – What is the use of BUILTIN\Administrators Group in SQL Server?
Any Windows login in BUILTIN\Administrators group is by default a SQL Server system administrator. This single group can be used to manage administrators from a Windows and SQL Server perspective