Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Access Rights through Roles
From:   Anomy Anom

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


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??


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023