Archives of the TeradataForum

Message Posted: Wed, 19 Dec 2001 @ 17:48:59 GMT

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

Jacques,

If you want to change a user's priority then you need to issue a "modify user" command. In order to do this you need the "drop user" privilege (or AccessRight) on the user concerned.

In a Teradata environment, ANY user can be granted the privilege to issue a particular command.

Assume that the user that you want to change the priority for is called "U1" and you want to use user SYSDBA to issue this command, then your database security administrator needs to issue the following;

GRANT DROP USER ON U1 TO SYSDBA;

Once this is done, SYSDBA can then issue the "modify user" command to change the priority for user "U1".

Dave

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