Archives of the TeradataForum

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

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

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>>