Starting in Teradata - ROLE/USER/PRIVILEGES/AUTHENTICATION - please help

Database
Enthusiast

Starting in Teradata - ROLE/USER/PRIVILEGES/AUTHENTICATION - please help

Hello to everyone :)

I'm new in teradata, and i have i few questions.

I'm running teradata database over vmware and I connect it on teradata with RazerSQL (installed on windows and connected to teradata on vmware)

1. Created new database from parent dbc

CREATE DATABASE SEMINAR FROM DBC AS PERM = 1000000;

2. Created new user for UBP database

CREATE USER EID FROM SEMINAR

AS

PASSWORD = EID

SPOOL=1000000

TEMPORARY=1000000

PERMANENT=1000000;

3. Created a few table

CREATE TABLE EID.MATERIJAL

(MATERIJAL INTEGER NOT NULL,

KATALOG VARCHAR(25),

OJ INTEGER,

PODGRUPA VARCHAR(25),

NAZIV VARCHAR(50),

JM VARCHAR(25),

ARHIV VARCHAR(25),

PDV NUMBER(25),

PRIMARY KEY (MATERIJAL))

4. And do a insert (example for one row)

INSERT INTO EID.MATERIJAL

(MATERIJAL,KATALOG,OJ,PODGRUPA,NAZIV,JM,ARHIV,PDV)

VALUES

(1,'1',1,'1','Juneće mljeveno meso','kg','',25);

The question is:

How to give a permission/privileges/role to created user, when he connect to database with GUI software (I'm using RazorSQL), that the user (EID) does not see any other object, outside his database SEMINAR.

I'm a little bit confused with user manual of teradata, because I can't find and I'don't understant this mechanism.

Please help me with answer and SQL code, not with a link on user manual. I'm doing this last 27 ours.

You can see the problem on image.

1 REPLY
Teradata Employee

Re: Starting in Teradata - ROLE/USER/PRIVILEGES/AUTHENTICATION - please help

To filter the objects the user can see, several steps would be needed:

  • Be sure the optional "X views" are installed: DBC.DatabasesVX, DBC.TablesVX, DBC.ColumnsVX, DBC.TableSizeVX and granted to PUBLIC (Or to User/Role in the unlikely event that there are some users who should not be allowed any metadata access whatsoever.)
  • Revoke the user's access to the views without the X suffix (for enforcement, skip this if you are just testing to see the effect)
  • In the ODBC/JDBC connection, set the UseXViews option (check the box in Windows ODBC configuration, add USEXVIEWS=ON to JDBC string)