Lol my mistake with the earlier answer.
I had allready created user by using script similar to generated from Teradata Administrator.
The ony questions are:
GRANT ALL ON user_TEST to SysDBA2 with grant option;
GRANT insert, select, restore, dump, checkpoint, table, create view, create macro, create trigger, create database on user_TEST to arch;
I saw them in qery log but those seem not to be some application added commands.
Are those some default one anyway?
CREATE USER "user_test" FROM "GRP_US_TEST"
AS PERM = 0
PASSWORD = "**********"
SPOOL = 300000029651.763
TEMPORARY = 50000001362.8211
ACCOUNT = ('$AL$ANAL&S&D&H')
STARTUP = ''
DEFAULT DATABASE = "VD_US_TEST"
NO BEFORE JOURNAL
NO AFTER JOURNAL
COLLATION = HOST
DEFAULT CHARACTER SET LATIN
grant select on VD_US_TEST to user_TEST;
grant select on VD_US_TEST_TEST to user_TEST;
grant select on VD_US_TEST_TEST_TEST to user_TEST;
You can run the ddl to create what you need in bteq. Make sure the logon id you're using has Create database and create table privileges.