This blog covers Unix system administration HOWTO tips for using inline for loops, find command, Unix scripting, configuration, SQL, various Unix-based tools, and command line interface syntax. The Unix OS supports tasks such as running hardware, device drivers, peripherals and third party applications. Share tips/comments. Read the comments. But most importantly: Read Disclaimer - Read Disclaimer.

Thursday, July 05, 2007

Change Default Database for Sybase User

Here is a quick way to change the default database for a user in Sybase. This is a fairly common database administration (DBA) task which I have done on several occasions. The change can be done with the sp_modifylogin stored procedure. In the SQL example below, the esofthub login is being assigned the esoftdb as its defaultdatabase. Here is its syntax.

Lists

Feeds

Feedburner

Disclaimer

If you use these tips, the author is not responsible for any adverse effects to your platform. Use these tips at your own risk. Do your own due diligence! These tips are intended as general guidelines and may vary from platform to platform. These tips are not the opinion of any vendor, and the author IS NOT associated/endorsed by any vendor. The author does not endorse any vendor.