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
PASSWORD = EID
3. Created a few table
CREATE TABLE EID.MATERIJAL
(MATERIJAL INTEGER NOT NULL,
PRIMARY KEY (MATERIJAL))
4. And do a insert (example for one row)
INSERT INTO EID.MATERIJAL
(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.
To filter the objects the user can see, several steps would be needed: