The system security officer can use create login 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. Sybase recommends that you do not set up a visitor account to be used by more than one user because you cannot maintain individual accountability.
You can use create login to add a visitor user account named “guest” to master..syslogins. This “guest” user account takes precedence over the system “guest” user account. 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.
