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 that I can do this for any database: USE any_db; SHOW TABLES; Regards, Lukas On Mon, May 30, 2016 at 7:34 PM, Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > 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 hduser > asehadoop hduser > default public > iqhadoop hduser > mytable_db hduser > oraclehadoop hduser > test hduser > 7 rows selected. > > However, that is just a list. It does not mean you have access rights to > that database. > > HTH > > Dr Mich Talebzadeh > > > > LinkedIn * > https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > > On 30 May 2016 at 18:20, Lukas Lalinsky <lukas.lalin...@exponea.com> > wrote: > >> I'm setting up a Hive instance with the SQL standard authorization and it >> seems to be working great for all normal operations, but for SHOW >> DATABASES/TABLES it's behaving differently from what I would expect. >> >> It always shows all databases/tables, even though I do not have access to >> those tables. Is that the intended behavior? Or is there something that can >> be done to filter out items which I can't access? >> >> Regards, >> >> Lukas >> > >
