yeah thank you so much Peyman Mohajerian ,is there any other way to make it dynamic?
On Sat, Nov 29, 2014 at 7:54 AM, Peyman Mohajerian <mohaj...@gmail.com> wrote: > You can use a database, store the users records in there and lookup the > username/password from there using a simple JDBC. > For example you maybe able to use the same database that is keeping Hive > metadata, mysql or postgres typically. > > On Fri, Nov 28, 2014 at 8:55 PM, prasad bezavada <prasadbezav...@gmail.com > > wrote: > >> Thank you so much for your reply .I already tried this custom/pluggable >> authentication , i have implemented a PasswdAuthenticationProvider class >> that validates the given username and password while connecting to hive >> from java program,but here the list of usernames and password I saved in >> one property file kind of file , when ever i want to connect to hive it >> just checks that the given username & password with the entries in that >> property file, if entry is there then it will allow us to connect otherwise >> throws an error. And if we want to add an user simply we can add an user in >> that property file.But I don't want to use this property file or anything >> ,I just want to do it dynamically .Is there any way to do that ?Like we do >> entries in LDAP. Please Let me know.. >> >> On Fri, Nov 28, 2014 at 10:49 PM, Peyman Mohajerian <mohaj...@gmail.com> >> wrote: >> >>> If you don't want to deal with LDAP, I know of one other way: >>> >>> <property> >>> >>> <name>hive.server2.authentication</name> >>> >>> <value>CUSTOM</value> >>> >>> </property> >>> >>> <property> >>> >>> <name>hive.server2.custom.authentication.class</name> >>> >>> <value>xxxx</value> >>> >>> </property> >>> >>> You can implement: PasswdAuthenticationProvider and you put your >>> implementation class in (xxx). I think these guy have some examples: >>> >>> from http://shiro.apache.org/ >>> <http://shiro.apache.org/download.html#latestBinary> >>> >>> But I haven't looked into it myself. >>> >>> >>> >>> >>> >>> >>> On Fri, Nov 28, 2014 at 5:05 AM, prasad bezavada < >>> prasadbezav...@gmail.com> wrote: >>> >>>> Hi , >>>> >>>> >>>> I am writing a java program to connect with hive and query the >>>> data from hive. From my program i am connecting to hive as follows >>>> private static String driverName = >>>> "org.apache.hadoop.hive.jdbc.HiveDriver"; >>>> public static void main(String[] args) throws SQLException { >>>> try { >>>> Class.forName(driverName); >>>> } catch (ClassNotFoundException e) { >>>> // TODO Auto-generated catch block >>>> e.printStackTrace(); >>>> System.exit(1); >>>> } >>>> Connection con = DriverManager.getConnection( >>>> "jdbc:hive://localhost:10000/default", "hive", "any"); >>>> Statement stmt = con.createStatement(); >>>> .... >>>> My Problem is, the above connection is not taking the password ,i >>>> mean with any username and password it is allowing me to connect and ge >>>> get the data from hive. But I want to restrict this and want to >>>> provide security so that >>>> only the specified user would be able to connect and query hive. >>>> I tried :pluggable authentication and its working fine. >>>> But i want to do it dynamically. >>>> i don't want to use LDAP or Kerberos. >>>> >>>> is there any way to do that? >>>> >>>> and can we create users and roles in hive >>>> ?if possible then how? >>>> when i use the command create role role_name its giving error i.e >>>> something like hive authorization incomplete or disabled >>>> >>>> >>>> >>>> >>>> >>> >> >
