Archives of the TeradataForum

Message Posted: Thu, 14 Oct 2010 @ 10:00:24 GMT

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

Hi Anomy,

1. Create a view on dbc.users from a database/user that has all neccesary privileges on all users.

2. Ensure you have select privs on this new view 3. Ensure database/user containing the view has "select with grant option" for dbc.

Kind regards

Etienne Stieger
DW DBA, Technical Specialist
Analytics and Information Management (AIM/EIW)
Standard Bank

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