In user databases, the Database Owner adds a guest user that permits all Adaptive Server users to use that database. This saves the owner from having to use sp_adduser to explicitly name each one as a database user.
You can use the guest mechanism to restrict access to database objects while allowing access to the database.
For example, the owner of the titles table could grant select permission on titles to all database users except “guest” by executing these commands:
grant select on titles to public
sp_adduser guest
revoke all on titles from guest
