Product: Aqua Data Studio
Version: 16.0.5-4
Build #: 43835
Build Date: 2015-May-04 10:13:45 AM
Operating Environment: Linux (3.13.0-41-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.7.0_60-b19
Memory: Max=704,643,072; Total=401,604,608; Free=272,248,400; CPUs=8
Connect Teradata-15.0.0.8
//Create User(User name 31 characters)
CREATE USER "LY_LOMBARDI_072014_032015_TRANS" FROM DBC AS
PASSWORD = "AqUa~`!@#^><",
PERMANENT = 3424234.0 BYTES,
SPOOL = 3.9604322304E10 BYTES,
TEMPORARY = 3.9604322304E10 BYTES,
NO FALLBACK,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
ACCOUNT = 'DBC',
COLLATION = Host,
DEFAULT CHARACTER SET Latin
GO
When we execute Above script,Create user and database at time
Expand Database node and User node.
Observation:
1)User name displayed 30 character in user tree node .
2)Database name displayed 31 character in database tree node.
When,we try to drop "LY_LOMBARDI_072014_032015_TRANS" user,It's give eror meassage "[Teradata Database] [TeraJDBC 15.00.00.20] [Error 3802] [SQLState 42S02] Database
'LY_LOMBARDI_072014_032015_TRAN' does not exist."
Because there are no X views for the users table didn't get the V for 14.1 and above. This is now fixed for users table tree extract and ddl extraction. Went through and looked at the tree node for teradata to make sure there are no other catalog views that had the same issue. requires testing...