Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 25 Oct 2012 @ 23:14:15 GMT


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


Subj:   Re: Users access not getting revoked!
 
From:   Pluebell, Fred

Query DBC.AllRightsV to see what unwanted rights are still granted to whom. Once you know exactly which rights to revoke, there should be no problem doing so as user DBC.

Check if perhaps the rights were granted to "PUBLIC" (all users) instead of or in addition to individual users; also see if rights were perhaps granted both at individual object level and at database level (tablename "All").

You may also want to double check DBC.RoleMembersV to verify which roles are assigned, and DBC.AllRoleRightsV to see what access rights are conveyed by each role.



     
  <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: 23 Jun 2019