[jboss-user] [Datasource Configuration] - Re: Datasource security

Nicolas Davyt do-not-reply at jboss.com
Fri Dec 3 08:41:35 EST 2010


Nicolas Davyt [http://community.jboss.org/people/nicolasdavyt1234] created the discussion

"Re: Datasource security"

To view the discussion, visit: http://community.jboss.org/message/574268#574268

--------------------------------------------------------------
Maybe you cant try with define 2 or 3 <jndi-name> with diferent username and password with respective privileges defined at the database. (only select, full acces, etc)

*<local-tx-datasource>
    <jndi-name>TradeTestOracle_ONLY_SELECT_DS</jndi-name>
    <connection-url>jdbc:oracle:thin:@trmpd_pkg.bankers.com:1521:trmpd</connection-url>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <max-pool-size>100</max-pool-size>
    <user-name>boatradeONLY_SELECT</user-name>
    <password>test1</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
    <metadata>
      <type-mapping>Oracle9i</type-mapping>
    </metadata>
  </local-tx-datasource>*

*<local-tx-datasource>
    <jndi-name>TradeTestOracle_ALL_ACCESS_DS</jndi-name>
    <connection-url>jdbc:oracle:thin:@trmpd_pkg.bankers.com:1521:trmpd</connection-url>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <max-pool-size>100</max-pool-size>
    <user-name>boatrade**_ALL_ACCESS_**</user-name>
    <password>test1</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
    <metadata>
      <type-mapping>Oracle9i</type-mapping>
    </metadata>
  </local-tx-datasource>*

And in you code like for example:   (in your dataBase Connection class.)

public static Connection getConnection( User user)

......
if (user.equals("Bob"))
     ds = (DataSource) iniCtx.lookup("*TradeTestOracle_ONLY_SELECT_DS"*);
else if (user.equals("John"))
     ds = (DataSource) iniCtx.lookup("*TradeTestOracle_ALL_ACCESS_DS**"*);
.......
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/574268#574268]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20101203/65a49d62/attachment.html 


More information about the jboss-user mailing list