Oracle definitly has a different security model than SQLServer. The
approach that you are taking is appears tob e a SQLServer appraoch to
locking down the row in the external database. Oracle uses row level
secuirty to accomplish this same concept. You would allow select on the
external table but control what rows user1 has access to....
"Arun Gopalam" <nospam@nospam.nospam> wrote in message
news:%23oHjdsNGFHA.2736@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I am from SQL server background
> this question is regarding oracle
>
> I have a oracle procedure which executes a query to access external
> databases
> the procedure is owned by a user called owner
>
> i am trying to run a vb application under credentials user1(who does not
> have permissions to run the external query in the stored procedure) i am
> getting access denied error
> user1 has permissions to run the stored procedure
>
> when run from sqlplus both user1 and owner can execute the stored
> procedure
>
> my friend says that when executing stored procedure owned by owner
> it should run under credentials of owner and not under user1
>
> Help me please ...!
>
> Arun
>
>
>
>
Re: Error in calling stored procedure via DB link ..."Paul Clement" wrote: ... Below is an Oracle KB article that documents the issue. ...Calling Stored Procedure over Dblink Using Oracle OleDb Provider Fails ... > symptom: Using command type adCmdStoredProc... (microsoft.public.vb.database.ado)
Re: Performance problems with StoredProcedure in Web application ... you could probably just ignore my comments about stored procedure performance as compared to textual queries because they ... As for your question about how to avoid using a cursor (as I suggested was possible in Oracle) read the following paragraph for more ... The .NET Framework Data Provider for Oracle does not support batched SQL statements....CURSOR output parameters to fill a DataSet, ... (microsoft.public.dotnet.languages.csharp)
Re: Passing Back Table Information from Oracle .NET Stored Procedures ...stored procedure, not in the typical PL/SQL sense.... I don't care if it's MS SQL in-line code or Oracle in-line code, MS SQL Server, Oracle Proc, or this so called .NET Stored Procedure using a Select statement, they are all returning a RESULT SET whether it be one row or multiple rows. ... I used SqlContext above because I don't want to bother registering at the Oracle site to download their Oracle Database Extensions for .NET in order to get at the presumably extant OracleContext class. ... (microsoft.public.dotnet.languages.csharp)
Re: EXEC syntax for SP which returns row set ... >>> Oracle experts, none of whom seem to know. ... >> SQL> create or replace package returncur is ... > I don't know why you are supplying the above example. ... to illustrate HOW you'd call a stored procedure and return ... (comp.databases.oracle.server)
