The guest User
The guest user is created by default in each database when the database is created. This account allows users that do not have a user account in the database to access it. By default, the guest user does not have permission to connect to the database. To allow logins without a specific user account to connect to the database, you need to grant CONNECT permission to the guest account. You can run the following command in the target database to grant the CONNECT permission:
GRANT CONNECT TO GUEST
When the guest account is granted CONNECT permission, any login can connect to the database. This opens a possible security hole. The default permissions for the guest account are limited by design. You can change the permissions for the ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
