Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 14 Aug 2007 @ 18:48:25 GMT


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


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



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023