Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 21 Dec 2002 @ 20:20:33 GMT


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


Subj:   Access Rights
 
From:   Jim Downey

I am not a DBA so I am not familiar with granting rights. For most of our databases, we have separate databases for tables, views, macros.

I have a database with several tables, views and macros. What is the most efficient way to grant the following to ALL users:

No one should be able to access a table.
Everyone should be able to access any one of dozens of views.
Everyone should have the ability to execute any one of 7 macros.

The macros control how users can find, insert, update, delete rows within the tables.


Thanks

Jim



     
  <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