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
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 ...