Controlling Object Creation in the master Database

When you install SAP ASE, only a system administrator can create objects in the master database, because the system administrator implicitly becomes the database owner ( “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 Security Administration Guide > Managing SAP ASE Logins and Database Users.

Create any system procedures in the sybsystemprocs database rather than in master.