A NEW DBA DOUBT - I AM ABLE TO SEE USERS FROM ADMIN CONSOLE BUT NOT FROM DBC.USERS

General
SSM
Fan

A NEW DBA DOUBT - I AM ABLE TO SEE USERS FROM ADMIN CONSOLE BUT NOT FROM DBC.USERS

Dear All, 

 I AM ABLE TO SEE USERS FROM ADMIN CONSOLE BUT NOT FROM DBC.USERS, i know my id has to get privialge to access the dbc.users...but how teh same ID is able to see the user name, under same id which ran select from dbc.users ?

Tags (1)
3 REPLIES
SSM
Fan

Re: A NEW DBA DOUBT - I AM ABLE TO SEE USERS FROM ADMIN CONSOLE BUT NOT FROM DBC.USERS

to make it simple... when i run select * from  dbc.rolemembers where grantee like 'XYZ' from sql assitant, it doesnt give any output, where as when i run the same query from teradata administrator's query window its giving output, what is the difference here ? i am getting confused 

SSM
Fan

Re: A NEW DBA DOUBT - I AM ABLE TO SEE USERS FROM ADMIN CONSOLE BUT NOT FROM DBC.USERS

In case you dont understand question I shall repeat it again..!!

I have logged in to Teradata sql assitant , by an id which has minimal privilages on teradata. and 

Junior Contributor

Re: A NEW DBA DOUBT - I AM ABLE TO SEE USERS FROM ADMIN CONSOLE BUT NOT FROM DBC.USERS

I don't fully understand your problem, but:

dbc.Users doesn't return all users, only those where the submitting user has DROP rights or is an owner (it's an X-view without X). Btw, better use UsersV instead, usage of non-V views is deprecated since TD12).

Different results for the same query might be related to the session mode, ANSI sessions compare case sensitive, but Teradata session case insensitive. Check using

SELECT Transaction_Mode FROM dbc.SessionInfoV WHERE SessionNo = SESSION