Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Role access
From:   Minakshi Swami

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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023