Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 01 Sep 2014 @ 12:42:57 GMT


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


Subj:   Re: Revoke Access on a particular object
 
From:   Dave Wellman

Hi Vamsi,

If I've understood your requirement correctly, you can't.

Assume a user has SELECT on db1.

If you want to prevent them from selecting from db1.t1 you cannot do it using access rights.

You either have to move t1 to another database, or revoke the database level access right and then grant at the object level for all other objects in database db1.

You may be able to achieve this using row level security (I don't know), but that is "a whole different ball game".

If I've misunderstood then can you please give an example of what you are trying to do.


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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