SQL Database Concepts Question:
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..
| Previous Question | Next Question |
| Do you know what is difference between Index Seek vs. Index Scan? | Explain what is ROW_NUMBER function? |