All Forums Database
Karthi_teradata 3 posts Joined 09/15
09 Sep 2015
Newbie to Teradata

All,
 
I am newbie to Teradata database. I have been working in SQLServer, Sybase and Oracle since 2003. But I am new to Teradata database.
 
When I ran the below query , I got the "Select Permission denied" kind of error message.
 
In SQL,Sybase sysprotect table will give you the information like below
 
Table Name    Permissions   userid
employee        Select           kk
employee        Insert           kk
employee        update          kk
employee        delete           kk
employee        Insert           k1
As per the above example, UserID k1 can insert the data into 'employee' table but he can't run 'select' statement.
 
I want to know such information/report in teradata. 
 
Inputs are welcome!
 
 
 

Karthi_teradata 3 posts Joined 09/15
09 Sep 2015

@@version is used to see the version details in sql/sybase. 
Kindly tell me how to check the version through query not with the support of tool.
 
 

dnoeth 4628 posts Joined 11/04
10 Sep 2015

All metadata is found in dbc-views, details can be found in the Data Dictionary manual.
 
Access rights for all users/databases: dbc.AllRightsV
Access rights based on roles: dbc.AllRoleRightsV
Access rights for the current user: dbc.UserRightsV
Access rights for the current user's role: dbc.UserRoleRightsV
 
Teradata version: dbc.DBCInfoV

Dieter

Karthi_teradata 3 posts Joined 09/15
10 Sep 2015

Thanks dnoeth!
 
Can you refer some good books to read about  TeraData architecture and programming ?

You must sign in to leave a comment.