All Forums Database
Rahzz 4 posts Joined 04/14
06 Aug 2014
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:
cmedved 24 posts Joined 02/14
06 Aug 2014

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.

Rahzz 4 posts Joined 04/14
07 Aug 2014

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?

dnoeth 4628 posts Joined 11/04
07 Aug 2014

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

Dieter

Rahzz 4 posts Joined 04/14
07 Aug 2014

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.

You must sign in to leave a comment.