When you install Adaptive Server, only a system administrator can create objects in the master database, because the system administrator implicitly becomes “dbo” of any database he or she uses. Any objects created on the master database should be used only for system administration. Set permissions in master so that most users cannot create objects there.
WARNING! Do not place user objects in master. Storing user objects in master causes the transaction log to fill quickly. If the transaction log runs out of space completely, you cannot use dump transaction commands to free space in master.
You may also want to use alter login to change the default database for users (the database to which a user is connected when he or she logs in). See Chapter 3, “Managing Adaptive Server Logins and Database Users,” in the Security Administration Guide.
Create any system procedures in the sybsystemprocs database rather than in master.
