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 Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023