The System Security Officer can use sp_addlogin to enter a login name and password that visiting users are instructed to use. Typically, such users are granted restricted permissions. A default database may be assigned.
WARNING! A visitor user account is not the same as the “guest” user account. All users of the visitor account have the same server user ID; therefore, you cannot audit individual activity. Each “guest” user has a unique server ID, so you can audit individual activity and maintain individual accountability. Setting up a visitor account to be used by more than one user is not recommended because you lose individual accountability.
You can add a visitor user account named “guest” to master..syslogins using sp_addlogin. This “guest” user account takes precedence over the system “guest” user account. Note that, if you add a visitor user named “guest” with sp_adduser, this impacts system databases such as sybsystemprocs and sybsystemdb, which are designed to work with system “guest” user in them.
