Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 03 Apr 2010 @ 20:45:07 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Revoke logon on all as default
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, March 30, 2010 10:37 -->

We are moving our production system this weekend. Normally we DISABLE LOGONS / ENABLE LOGONS from CNSTERM 6 before and after system shutdown.

This weekend we will have an 8 hour window after we DISABLE LOGONS where we will be backing up the system. I want to individually grant logons to my backup job IDs.

The TD Knowledge Base & 12.0 Documentation shows the following sql to be run from BTEQ as an option to DISABLE LOGONS:

     GRANT LOGON ON ALL TO backupuser;

The sql executes successfully, but logons are still enabled (no changes take place).

I ve tried running the REVOKE LOGON ON ALL AS DEFAULT sql only in BTEQ and logons are still enabled (output below).

I ve tried DISABLE LOGONS from CNSTERM 6 (this works) then GRANT LOGON ON ALL TO backupuser from BTEQ (this does not work).

Our 12.0 release and version are shown below. Am I missing something or do I need to follow up with the GSC?

     BTEQ Tue Mar 30 10:24:13 2010
     .logon tstedwdb/dbc,
     *** Logon successfully completed.
     *** Teradata Database Release is
     *** Teradata Database Version is
     *** Transaction Semantics are BTET.
     *** Character Set Name is 'ASCII'.
     *** Total elapsed time was 3 seconds.
     *** Logon has been revoked.
     *** Total elapsed time was 1 second.
     *** You are now logged off from the DBC.

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023