Hello aleksey2001.

I do internal audit work. My ability to work with information through SQL Server is much greater than in Oracle. Collecting Oracle environmental data through SQL Server...

Great article. It's so much easier to gather Oracle information from SQL Server than Oracle itself.

Thanks Eric. In the four years the thread has been open that's probably the most effort anyone has put into the answer. It's not what I was really...

I found my own answer:

SELECT * FROM sys.sql_logins

Thanks.

Hello Chris:

Thanks.  It's the second part of your response that's more interesting, and more to the point of what I'm looking for.  I'm not considering other applications that can access...

Hi Greg:

Thanks.  I knew that reply was coming.  I would like to set that aside, and still pursue the question. 

This is about denying people the ability to use tools...

I hope this can be of some help to get people going:

• Control access to the database environment. 

• Only give people the bare minimum rights necessary.
• Have access authorized (you may need...

The last thing I want to do is push an auditor into doing a deeper audit, but they don't seem to understand tiered architecture.  I would agree with you that...

I think I really appreciate any website where the advertising doesn't take you to a pornographic or gambling site.  I appreciate that 50 windows don't pop up along with the...

Thanks Sreejith.  I appreciate that, and knowing any other ways people have handled things.

I can confirm what you're saying for the encrypt function, but not when encrypting a stored procedure.  A true test of encryption over encoding is whether or not...

That's quite a misnomer calling it encryption.  Thanks for the example.  I had fun with that.

Hi Oskar:

Thanks for the reply.  In my organization we have some people who are looking into adding the encrypt clause to stored procedures prevent tampering.  This may prove reasonable, but...

 Hi:

Is there a reference link that explains Microsoft's support limitations with the encrypt function?  Also, is it the same encryption used to encrypt stored procedures.

Thanks.