Grant the user permissions on sysudtlib and sysspatial:
create user geouser as perm=1e9 password=geouser; grant all on dbc to geouser with grant option; grant all on sysudtlib to geouser with grant option; grant all on sysspatial to geouser with grant option;
The following is a BTEQ example to create the user and grant permissions on sysudtlib and sysspatial:
C:\Program Files\Teradata\Client\17.20\bin>bteq .logon NODEID/dbc,dbc Teradata BTEQ 17.20.00.01 (64-bit) for WIN64. PID: 11492 Copyright 1984-2022 Teradata. All rights reserved. Enter your logon or BTEQ command: .logon NODEID/dbc, *** Logon successfully completed. *** Teradata Database Release is 17.10.03.01 *** Teradata Database Version is 17.10.03.01 *** Transaction Semantics are BTET. *** Session Character Set Name is 'ASCII'. *** Total elapsed time was 2 seconds. BTEQ -- Enter your SQL request or BTEQ command: create user geouser as perm=1e9 password=geouser; create user geouser as perm=1e9 password=geouser; *** User has been created. *** Total elapsed time was 1 second. BTEQ -- Enter your SQL request or BTEQ command: grant all on dbc to geouser with grant option; grant all on dbc to geouser with grant option; *** Grant accepted. *** Total elapsed time was 1 second. BTEQ -- Enter your SQL request or BTEQ command: grant all on sysudtlib to geouser with grant option; grant all on sysudtlib to geouser with grant option; *** Grant accepted. *** Total elapsed time was 1 second. BTEQ -- Enter your SQL request or BTEQ command: grant all on sysspatial to geouser with grant option; grant all on sysspatial to geouser with grant option; *** Grant accepted. *** Total elapsed time was 1 second. BTEQ -- Enter your SQL request or BTEQ command: .logoff; .logoff; *** You are now logged off from the DBC. Teradata BTEQ 17.20.00.01 (64-bit) for WIN64. Enter your logon or BTEQ command: .quit; .quit; *** Exiting BTEQ... *** RC (return code) = 0