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 ?
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
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
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