SQL Database Concepts Question:
Download Job Interview Questions and Answers PDF
Explain what is Public Role in SQL Server?
Answer:
Every database has a public role which holds all the default permissions for the users in a database. This role cannot be dropped and cannot have roles or groups assigned. For security reasons, permissions granted to public role should be minimized..
Download Basic SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Do you know what is difference between Index Seek vs. Index Scan? | Explain what is ROW_NUMBER function? |