Archives of the TeradataForum

Message Posted: Wed, 21 Dec 2005 @ 09:48:38 GMT

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

Hi,

We are using ROLE level access permission. Every time when the user logs in, he has to set the role in the current session to activate the access rights.

Do we need to set the Role every time for each session? We can do the same in case of BTEQ script. But how to handle that in Fastload/Multiload scripts.

We are getting error while executing the "SET Role <rolename>" command after the login statement in Fastload script. Without that user cannot create the error/UV table. How to avoid setting role in this case?

Thanks

Rishi

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