Omitting user name and password from login scripts

Posted on 2008-11-18
Last Modified: 2013-11-11
I have some lengthy SQL scripts that I wish to run in BTEQ, and I wish to automate the process as much as possible.  I would prefer to have a login screen that logs me in and then automatically runs my script, rather thanforcing me to build a login script that includes the user name and password.  

In short, I do not wish to compromise security in the quest for greater convenience.  Your suggestions are most welcome.

Thanks, ~Peter Ferber
Question by:PeterFrb
    LVL 19

    Expert Comment

    I'm no expert with TeraData, but if you're running on Windows, there's a terrific automation tool you could use to automate just about any Windows user interface. It's called AutoIt, and it uses a very easy vb-like scripting language to create applets that can interact with applications, processes, files, etc. Scripts can be run directly, or compiled into executables. It's powerful, easy to use, and completely free.
    LVL 1

    Expert Comment

    See Chapter 2 (Logon Security) in Security Administration on It contains some information about the possibility to log on without using a password.
    LVL 13

    Accepted Solution

    BTEQ script can be run as:


    Put the following code in the beginning of your bteq script:

    .LOGON yourserver;

    But in this case BTEQ tries to use NULL values for user and password at first. Prepare for a short delay before logon screen is displayed.

    Author Closing Comment

    This is how I ended up using the application.  Sorry for the delay in assigning points.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Note: You must have administrative privileges in order to create/edit Sharing Rules. ( (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales an…
    "Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now