Archives of the TeradataForum

Message Posted: Tue, 21 Nov 2006 @ 14:19:46 GMT

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

Here is an excerpt from the Database Administration manual Release V2R6.1, B035-1093-115A, November 2005.

IF you want to ...

control privileges at the group level

THEN use the...

following procedure:

1 Log on as user DBC and grant to your database administration user (such as DBAdmin) the CREATE ROLE privilege, including the WITH GRANT OPTION. For example:

          GRANT CREATE ROLE TO DBAdmin WITH GRANT OPTION;

2 Log off as user DBC and log on again as your database administrator.

3 Use CREATE ROLE rolename statements to define one role for each set of privileges per group.

4 Grant the appropriate privileges to each role.

5 Grant one or more roles to one or more users until all users in all groups have the necessary privileges.

I think this might answer your question.

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