User not listed in DBC.UsersV

Database
Fan

User not listed in DBC.UsersV

Hi,

Some of the users I am creating are not getting listed in DBC.usersV but listed in DBC.databasesV only.

Why I am not able to view user in UsersV?

Requesting your help here

Thanks in advance

Tags (1)
4 REPLIES
Enthusiast

Re: User not listed in DBC.UsersV

https://forums.teradata.com/forum/database/grant-select-on-dbc-users-for-typicall-user

DBC.UsersV shipped with the code of a typical "VX" view restricted to showing only the current user... at least for our 13.10 site. We made a Users view without the restricting code in another database for convenience.

Fan

Re: User not listed in DBC.UsersV

Thanks for your reply .

I have privilege to view all the users.

while i am selecting information  DBC.UsersV contains 193 users, but DBC.databasesV contains 251 databases with DbKind= U.

 59 users are not listed in DBC.UsersV.Why these users listed as database only not as users?

Junior Contributor

Re: User not listed in DBC.UsersV

You need to be an owner of a user or the DROP USER right to see them in dbc.UsersV

Fan

Re: User not listed in DBC.UsersV

Thanks for your fast reply Dieter.

I checked and found that I dont have CREATE/DROP User privilege on these users.

Tanks for your help.