December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 UnleashedBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...