Copyright 2003 Alpha-G Consulting, LLC. All rights reserved.

Delivery Method

The Read-only Login utility program is delivered (and kept up-to-date) via the Sun Java Web Start tool; the utility itself is free of charge, but you must request it from the Managing Partner via Email Alpha-G. Alpha-G responds to your e-mail with a link to load the free utility. Read-only Login is not only useful in its own right, but is great for testing the Java Web Start delivery/deployment setup (which is also used for other Alpha-G Java utility programs).

To be able to use any of the Alpha-G Java utilities, you must have Java Web Start installed and ready to go. See this link for instuctions on how to do that:

Getting set up to Run Read-Only Login

Read-only Login Program Function

The Read-only Login utility program creates a Sybase login which has the ability to read the data in your Horizon/Sunrise database, but no permissions to make changes to your data: the permissions are read-only. Such a login is ideal for use with reporting packages and while learning to use SQL (such as via Alpha-G's SQL Patterns courses).

The program operates with a graphical interface. The user specifies the login to create and the database in which to create it. The utility itself requires either the SA login or a login which includes similar privileges. Read-only Login creates a login with the specified ID and password. Then it creates a user for this login in the indicated database (presumably a Horizon/Sunrise DB) and grants SELECT permission on all tables and views in that database. It also grants EXECUTE permission on most stored procedures defined in that database (some, which do insert, delete, or update operations are excluded). It also grants permission to create tables in tempdb. This means that a person logged in with this newly-created login could select data into a table in tempdb (and because of being the owner of the tempdb table, they would be able to select data from that table and modify it as desired--including dropping tables they created in tempdb).

Acceptance

Alpha-G represents that Read-only Login works substantially as described here. If, upon initial testing, you believe it does not function as described, Alpha-G may or may not choose to fix the problem. You are responsible for testing the utility program and determining its suitability for use in the intended application. Use of the program certifies that the customer has read and agreed to Alpha-G's Terms and Conditions (including limitations of liability and waiving of the right to sue Alpha-G) as posted at:

Alpha-G's Terms and Conditions

If you cannot agree to these Terms and Conditions, do not request the product.

Updates

Alpha-G may make enhancements and adjustments to the program and documentation from time to time. Java Web Start automatically retrieves program changes the next time the program is run. What documentation is available is on the utility's home page (which is accessible via the Java Web Start program manager). In the event that this program's functionality is merged into another tool at some later date, Alpha-G may discontinue making improvements or enhancements to this program. Customized changes to the program can be provided at Alpha-G's programming rates.

Licensing

The program is licensed to be installed and used on a single computer system. It may not be resold or transmitted to any third party. The program and its documentation are copyrighted by Alpha-G Consulting and all rights are reserved to the copyright holder.

Send product inquiries to the Managing Partner via Email Alpha-G

Horizon/Sunrise is a trade name of epixtech, inc. Sybase is a tradename of Sybase, Inc. Java and Java Web Start are tradenames of Sun Microsystems, Inc.