Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 12 Mar 2014 @ 14:57:55 GMT


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


Subj:   Roles and Collect Stats in Teradata
 
From:   Kothari, Mahesh

I have a user who can collect stats on all the tables in a database.

But when I check the access of the role which is assigned to user , It does not have collect stats access on that database. Also I have checked that there is no entry in dbc.allrights with access right = 'ST' for that database not even at table level.

Note : Creator of the tables are different from the user which is collecting stats , so it's not its own object.

The user has create table and drop table access at database level but no stats access , still it can collect stats how ?

Am I missing anything here to check.


Regards,

Mahesh Kothari



     
  <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: 27 Dec 2016