Karinpoky is a storage system instruct analyse middleware.
karinpoky-service: provide all the api which use to add or del or modify policy
karinpoky-parser: parse the sql(Hive sql, Mysql sql, TiDB sql, ArangoDB sql and others)
relational database: store all the policy
policy: contain all the privilege,for example : select,update,delete table or field
Many OLAP system for example hive,
or new database for exampl HBase, ArangoDB,TigerDB,
they have no complete permission system.
We can not restrict the permission of any user when we use theses system.
for example use Hive sql,Graph sql,or other sql .
but if u use karinpoky,u can restrict the the permission of any user.
karinpoky support:
Hive
Mysql
TiDB
Sqlite
ArangoDB
Thanks to our plug-in architecture, we can support any database.
In the future, karinpoky will support Oracle, Sqlserver, mongoDB.
public class Example {
private static final String URL = "jdbc:mysql:https://localhost:3306/test";
private static final String USER = "example";
private static final String PASSWORD = "example";
public static void main(String[] args) throws Exception {
String user = "Yanni";
String sql = "SELECT user_name, age FROM user";
Client client = KarinpokyClient.build();
boolean isAuthorized = client.checkPermission(user, sql);
if(!isAuthorized){
throw new RuntimeException("the user have no permission");
}
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getString("user_name")+" age："+ rs.getInt("age"));
}
}
}