Archives of the TeradataForum

Message Posted: Tue, 01 Feb 2011 @ 08:29:20 GMT

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

As you can have more than one role, you have to switch on a role within a session:

     .logon user1,....
     SET ROLE role_test1;

Now that role is active until User1 logs off, submits a SET ROLE NONE or switches to another role SET ROLE another_role.

or assign it as a default role to a user:

     MODIFY USER user1 AS DEFAULT ROLE = role_test1;

The main problem in implementing roles is to find out which roles to create (and which to nest).

And if you have lots of inherited rights the job revoking all those rights (don't forget the ALL keyword) and regranting them to the roles may run for quite a long time.

For nested Role:

     GRANT role1 TO role2;

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