Page History

...

We store privileges in one column, and use comma to separate different privileges.

hive> desc user;

Field

• - - -

User

isRole

isGroup

isSuper

db_priv – set (Select_priv, Insert_priv, Create_priv, Drop_priv, Reload_priv,

...

Lock_tables_priv, Create_view_priv, Show_view_priv)

hive> desc db;

Field

• - - -

Db

User

isRole

isGroup

Table_priv – set (Select_priv, Insert_priv, Create_priv, Drop_priv, Grant_priv,

...

hive> desc tables_priv;

Field

• - - -

Db

User

isRole

isGroup

Table_name

...

mysql> desc columns_priv;

Field

• - - -

Db

User

isRole

isGroup

Table_name

...