Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 16 Apr 2008 @ 15:13:45 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Extra security elements
 
From:   CELIAMM

Hello all,

I've been required to apply some security elements to users that can't be defined through CREATE USERS or CREATE PROFILE statements. On one hand, I have to force users to change their password first time the log into Teradata Database. On the other hand, I have to lock users that haven't been in use in the last 60 days.

First I though of inserting some code on STARTUP option in CREATE USER statement, so I could control security at logon. However, commands in STARTUP option only work if users logon in the database through BTEQ (http://www.teradataforum.com/teradata/20001214_181614.htm), and my users are going to logon in the database through web applications, SQL Assistant and BTEQ.

Then I decided to make a script that executes every day to check what users didn't log during the last 60 days. I need to update values in DBC.DBase in order to achieve this, but DBC user can't update this table. Any suggestion about what i can do?


Thanks.

Celia



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