Create a user with privileges to reset any user password

General
Highlighted

Create a user with privileges to reset any user password

Totally a noob when it comes to Teradata. But I need to know how to perform three tasks.

I just setup the Teradata Express VM for vmware. I am trying to create a NEW user who can do the following:

* select * from dbc.users

* modify any user's password up to and including DBC

* select * from dbcinfo

I am having a heck of a time figuring out the correct permissions or using the dbc user to grant various permissions to a new user. 

Any help would be much appreciated.

1 REPLY
Teradata Employee

Re: Create a user with privileges to reset any user password

To MODIFY another user's password, or to have dbc.UsersV return info for another user, the new user must have DROP USER permission on that other user. (So to meet your stated goal, you would need to grant DROP USER on all other users to that new user.)

But you can't grant DROP USER ON DBC. Only DBC can modify DBC's password.

By default SELECT is granted to PUBLIC for many of the DBC views.