|
What is Public Role in SQL Server?- 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.
- It is a special database role which belongs to user of every database.
- It captures all the default permission for users in a database.
- Public role cannot be dropped.
- It is used to protect against unauthorized data access, minimize the permissions granted to the public role.
|
