Newsletter #6, February 3, 2009

Migrating DB2 security items to SQL Server

Posted by admin on Feb 3, 2009 • (0)

There are three main mechanisms within DB2 that allow implementing a database security plan: authentication, authorization, and privileges. These mechanisms differ from those used in SQL Server.

AUTHENTICATION
DB2 Authentication defines who is allowed accessing to the instance and/or database, and where and how a user’s password will be verified. Different types of DB2 authentication can be [...]

Conversion of Oracle REF CURSOR used as OUTPUT Parameter

Posted by admin on Feb 3, 2009 • (0)

In this article, I am going to cover the situation when REF CURSOR type is used in output parameter of a stored procedure. Often this method is chosen to return the result set from a procedure to an application. Still, in many cases, the cursor reference can be returned from the stored procedure to outer [...]

1