VB-> ADO -> ORACLE

From: Arun Gopalam (nospam_at_nospam.nospam)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 12:36:19 -0000

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

Relevant Pages

  • Re: sql server slower than MS Access
    ... update query before actually committing the results. ... The clustered index is not on the columns being updated. ... I SET ROWCOUNT in the stored procedure to 100000, the query executes ...
    (microsoft.public.sqlserver.server)
  • Cannot perform BULK INSERT even though the account is a bulkadmin
    ... We have a stored procedure that dynamically constructs a BULK INSERT ... The account that executes this stored ... procedure is not the DB owner or table owner, ...
    (microsoft.public.sqlserver.security)
  • Re: Datatable Update
    ... using the value of a column in the row to query the db, ... and Rows to each respective valeu of the datareader or the output ... > the customer_id from the datatable and then executes a stored ... > stored procedure. ...
    (microsoft.public.dotnet.framework.adonet)
  • HELP..
    ... I tried by making the owner of the job as 'sa' and starting the job manually ... >> SQL SERVER 7.0 ... >> I created a SQL job which executes a stored procedure. ...
    (microsoft.public.sqlserver.security)
  • Re: CBO & different execution plans
    ... This is the query: ... The explain plan when the schema owner executes the query (good ... 536 TABLE ACCESS BY INDEX ROWID HTS_ASSAY_RESULT (cr=56 pr=4 pw=0 ...
    (comp.databases.oracle.server)