martedì 25 agosto 2009

Execute a procedure under another schema

Problem:
There are two users, A and B.
User A creates a procedure.
User B wants to run that procedure, but he wants to affect the tables of his own schema, not the tables of user A!

Solution:
You can simply add
authid current_user
in the package specification

Authid clause immediatly follows the create procedure, create function, create package or create type statement.

mercoledì 5 agosto 2009

Build a .NET Application on the Oracle Database with Visual Studio 2005 or 2008

Interesting quick tutorial about Oracle and Visual Studio: LINK