Back here on planet earth...

pavan.reddyshetty (12/21/2009)

---

User 'PC/Pavan' has db_owner role in 'ReportServer' and 'ReportServerTempDB' and datasource. Following is the screenshot. I know just basics of DB security. Let me know if I am looking...

steves06 (12/21/2009)

---

Our servers are both 10g and 11g. The one I was testing against the most is 11g. So I thought the 11g client might help. Maybe...

Well, a full reinstall of the Oracle client software (Oracle ODAC 10.2.2.21) fixed things. Twice before I had tried installing the 11g ODAC software and pointing to it and that...

Lynn Pettis (12/21/2009)

---

It isn't an end all or silver bullet. But that doesn't mean it isn't something that can be enhanced and further developed to enhance the security of...

David.Poole (12/21/2009)

---

One of the problems I found when switching to agile development practises was getting the non DB development team to accept architectural principles from the DB perspective.

The good architects...

Lynn Pettis (12/21/2009)

---

Standard answer here, It Depends. I would not have it as a default, but a development team working on a distributed app may see the usefulness of...

Lynn Pettis (12/21/2009)

---

I know, and you have to explicitly code for the encryption, you can't just encrypt the database like you can with TDE in SQL Server 2008 EE. ...

Lynn Pettis (12/21/2009)

---

If it can be done transparently at the database level there may be a better chance of developers making use of the technology when it is needed without...

Lynn Pettis (12/21/2009)

---

I could see developers writing client apps that using Compact and Express editions for holding data in flight locally. TDE may be necessary if those apps hold...

the company I work for is managing some hundred client sales applications in the pharm business. Most of these are express edition, some larger clients have workgroup edition. I'm a...

Our flows access SQL Server as well. And they access Oracle with the Attunity drivers. In all those cases there are no issues trying to configure and, when we disable...

steves06 (12/21/2009)

---

No, we tried all those suggestions several times. And, regardless of what we tried, we reverted everything back to just using package level passwords but those no longer...

I think you are missing EncryptSensitiveWithPassword option so check the thread below which also added the need for correct TNSNAMES.ORA file in the Oracle home folder. The second...

steves06 (12/21/2009)

---

That's the policy here. I'm a consultant so I'm not going to question it. I shouldn't have to change policy to get around what appears to be...