hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <>
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.


Dr Mich Talebzadeh

LinkedIn *

On 30 May 2016 at 18:20, Lukas Lalinsky <> 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

View raw message