hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Re: SHOW DATABASES/TABLES with SQL standard authorization
Date Mon, 30 May 2016 17:34:14 GMT
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.lalinsky@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
>

Mime
View raw message