The “public” role allows user to connect to the SQL Server instance and view databases. To grant database access to a domain user, this role must be manually assigned in SQL Server Manager Studio.