Archives of the TeradataForum

Message Posted: Tue, 05 Apr 2005 @ 10:38:10 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

The information related to username,permspace and password can be obtained from dbc.dbase table and the information related to rolenames and profilenames can be obtained from dbc.roles and dbc.profiles tables. Also the information as to which user is linked to which role and profile can be obtained from dbc.dbase table.

Thanks,

Vimala.

	<Prev	Next>		<<First	<Prev	Next>	Last>>