Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Oracle Proxy Authentication and BIRT(help needed)
icon5.gif   Oracle Proxy Authentication and BIRT [message #634806] Sat, 23 October 2010 18:27
marcin is currently offline marcinFriend
Messages: 1
Registered: October 2010
Junior Member
Hi all.

I'm a new user of BIRT application, actually I've started learning it and discovering mysteries around it.

I have one task which I hope could be resolved within BIRT.
I'd like to use sth which is called Oracle Proxy Authentication. This could be described briefly as following:

we have connection pool on application server (let's say Tomcat) established on one user - let's call him Big Application user. But we want to run our application using different user. How to do this?

Oracle 10 offers solution: Proxy Users. You can use Oracle's proxy users to connect to Oracle through one Big Application User and still pretend to be someone else. The big advantage: select USER in the database works as expected. Auditing still works, grants and roles still work.

This requires some steps to be done on Oracle Database side but this is clear for me. Below you can find Java snippet which is used for creating session using Proxy Authentication:
private void  proxyConnection() throws Exception {
  Properties properties = new Properties();
  properties.put("PROXY_USER_NAME", "pu_user_1");
  OracleConnection conn = (OracleConnection)DriverManager.getConnection(
  "jdbc:oracle:thin:pu_pool_user/pu_pool_user@localhost:1521:ora1012",
  properties);
  conn.openProxySession(OracleConnection.PROXYTYPE_USER_NAME, properties); 
  printUserInfo(conn);
  conn.close();
}



Here pu_pool_user is the Big Application user for which connection pool is created. pu_user_1 is Proxy User who will run BIRT report basing on his database privileges, roles etc. Here printUserInfo should return information for this proxy user.

I heard about setting sth in application context but I don't know how to do that exactly. Maybe Scripted Source will be better for that? Please tell me what could be the best solution here.

Thanks in advance
Marcin
Previous Topic:Apply "Optional Y series Grouping" only on one series
Next Topic:how to get request url in scripting(drilldown using URI)?
Goto Forum:
  


Current Time: Sun Nov 23 06:13:53 GMT 2014

Powered by FUDForum. Page generated in 0.29834 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software