Teradata Password Change.

[shriniwasb]

Hi,
I am new to this forum and would like to know how to change/update Password in Teradata database.

 

[tdatgod]

once logged on as the user or as someone who has permissions to operate on that user

Modify user password = blort;

 

[tdatgod]

Hi,
It would be nice to tell it who you you wanted to modify! SOrry Hast makes waste.

modify user BOB password = blort;

 

[shriniwasb]

Thanks! I tried that but it didn't work. Looks like I don't have permission to change the password.

 

[tdatgod]

WHat is the error?

It could be the DBA didn't give you Modify user rights because that would allow you to do something like....

modify user BOB , permspace = 1e9;

and give youself more diskspoace. I think we have a hole here. Let me check and get back to you?