Archives of the TeradataForum
Message Posted: Wed, 21 Dec 2005 @ 14:02:18 GMT
| Subj: | | Re: SET Role in Fastload |
| |
| From: | | Diane Wilson |
| | How to assign the default role to user. Do we need to use "Grant Role" command for that? You mean in that case we don't need to set the
role every time? | |
MODIFY USER theuser AS DEFAULT ROLE = thenewdefaultrole;
However,
You may not want to have the role as the default role, as the default role may also be required.
So if you GRANT rolename To username, then you wont need to set the role every time the user signs on.
The idea behind roles is that you can set up multiple roles and assign multiple roles to a user or group of users
Di
| 
