![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Tue, 14 Aug 2007 @ 18:48:25 GMT
Subj: | | Re: Owner Grant Access |
|
From: | | Dieter Noeth |
Bill Hassinger wrote:
| We are on V2R6.1. When a user tried to grant access to a co-worker to their default db the following error was returned. I thought the
user would have AUTOMATIC rights on their db to grant rights. I tried having the user give WITH GRANT OPTION rights to themself and got the same
error. How do we make it so the user is "automatically" given WITH GRANT OPTION rights to their own db? I tried having the user give WITH GRANT
OPTION rights to themself and got the same error. | |
Hi Bill,
the automatic rights of a new user are granted without grant option. If he creates a new object, then he's the creator (with grant option) and
can grant rights on that object to anyone else.
If you want the user to grant rights on the database level, an *owner* has to grant those with grant option:
grant select on userx to userx with grant option;
Dieter
| |