Hi All,

I'm curious about the use of role based security for applications like this
rather than name based.

Do you create multiple data sources with different roles and then only allow
the user to use the data source that corresponds to their access level?

Or are you implementing the role on an application-wide level to restrict
the app to certain types of access?

This gets a little confusing when referring to Tomcat because it uses a
similar (but different) concept of roles in its container managed user
validation.

Rick

----- Original Message -----

> Hello All,
>
> I've defined and used DataSource with Tomcat 4.1.2. Now it is time to
> test it under real account instead of SYSDBA user. My database security
> based on roles. So how to provide role parameter to DateSource in
> server.xml?
>
> Thanks ahead
>
> Andrew
>
> PS: which place below?
>
> <Resource name="jdbc/FE2" auth="Container"
type="javax.sql.DataSource"/>
> <ResourceParams name="jdbc/FE2">
> <parameter>
> <name>factory</name>
> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> </parameter>
> <parameter>
> <name>maxWait</name>
> <value>5000</value>
> </parameter>
> <parameter>
> <name>maxActive</name>
> <value>4</value>
> </parameter>
> <parameter>
> <name>username</name>
> <value>TOMCAT</value>
> </parameter>
> <parameter>
> <name>password</name>
> <value>12345</value>
> </parameter>
> <parameter>
> <name>url</name>
>
> <value>jdbc:firebirdsql:127.0.0.1/3050:/data/db?lc_ctype=WIN1251</value>
> </parameter>
> <parameter>
> <name>driverClassName</name>
> <value>org.firebirdsql.jdbc.FBDriver</value>
> </parameter>
> <parameter>
> <name>maxIdle</name>
> <value>2</value>
> </parameter>
> </ResourceParams>
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>