Archives of the TeradataForum
Message Posted: Wed, 16 Apr 2008 @ 15:13:45 GMT
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 (https://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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|