Connection Pool

2709444 Jun 11, 2015 7:33 AM

Hi All,

I have a doubt. My RPD has two connection pools "ConnectionPool1" and "ConnectionPool2". Now, I want to restrict a certain set of users to access only "ConnectionPool1" and rest all to use "ConnectionPool2"? Is there any way to achieve it?

1. Re: Connection Pool

Christian Berg Jun 11, 2015 8:01 AM (in response to 2709444)

The "Permissions" on the connection pool object in the RPD:

1 person found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Connection Pool

2709444 Jun 12, 2015 3:29 AM (in response to Christian Berg)

Sorry to open the thread. But I have a small question. Now can I say that object level security can be applied to connection pool as well?
Like Show 0 Likes(0)

Actions
3. Re: Connection Pool

asim cholas Jun 12, 2015 6:26 AM (in response to 2709444)

Nopes. Object level security is something you can do at presentation layer. In the subject areas you can provide permissions to users and reports and dashboards you can hide based on users.
Like Show 0 Likes(0)

Actions
4. Re: Connection Pool

rmoff Jun 12, 2015 8:01 AM (in response to 2709444)

Sorry to open the thread. But I have a small question. Now can I say that object level security can be applied to connection pool as well?

Not per connection pool (which wouldn't make much sense), but it can be applied to other RPD objects. Details: http://docs.oracle.com/cd/E28280_01/bi.1111/e10540/dataaccess.htm#BIEMG1433
Like Show 0 Likes(0)

Actions
5. Re: Connection Pool

Christian Berg Jun 13, 2015 3:47 PM (in response to 2709444)

Third "no", but I created an Enhancement Request for exactly that functionality back in 2011/2012. However I doubt that this will make it in - things like that aren't what you'd call "priority" these days.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.