ok that is different from seeing the list of databases. That is just schema
case in point in SAP ASE a normal RDBMS
> sp_addlogin someuser, someuser123, scratchpad
2> go
Password correctly set.
Account unlocked.
New login created.
(return status = 0)
1> exit
isql -U someuser -w1000
Password:
--
I realize it's just a list, but it's still not something I'd expect. The
difference compared to a normal RDBMS is that they typically have a CONNECT
privilege, which I can use to restrict the user to connecting to other
databases.
I'm also more concerned about SHOW TABLES. It just seems strange th
the behaviour is no different from a normal RDBMS.
show databases actually inquires Hive metadata table DBS.
select NAME, OWNER_NAME from DBS order by 1,2;
NAME OWNER_NAME
-- --
accounts hdus
