Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 15 Mar 2011 @ 16:10:58 GMT


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


Subj:   Access Rights through Roles
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, March 15, 2011 08:14 -->

Hi,

I am new to Teradata and trying to understand access rights through roles. Here is what I am doing,

1) Create a Database DB.

2) Create a user DB_USER with perm=0;

3) Create role DB_Access_role.

4) Grant DB_Access_role to DB_USER with admin option;

5) Grant create table, drop table, ins, sel, upd,del on DB to DB_Access_Role


When I log on to DBS through DB_USER and issue a query

     CT DB.Table1(a int);

I get Error 3254: The user does not have create table acess to Database DB. Can anyone tell me what am I missing here??


Regards



     
  <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