Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Tue, 14 Aug 2007 @ 16:28:13 GMT





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




Subj:   Owner Grant Access
 
From:   Hassinger, Bill



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.

     Grant All On user1-db To user2

Bill H





     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 24 Aug 2008