Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Location
    hyderabad
    Posts
    6

    Post Unanswered: uSERNAME IN DB TRIGGERS.

    I am using Oracle 8.0.3.0

    I have 2 users scott and tom

    both are having the same emp table.

    I created a trigger on scott.emp for auditing and wants to update tom emp table simultanously.

    So i tried to write

    if inserting then
    delete from tom.emp where emp_code =:new.emp_code;
    insert into tom.emp (select * from ...);
    end if;

    User tom is not accepting?

    Cam you kindly give the way.

    The user is having every right to do that. I tried in sql it is working


    gln

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: uSERNAME IN DB TRIGGERS.

    It should work OK. What error are you getting?

  3. #3
    Join Date
    Jan 2003
    Location
    Woking
    Posts
    107

    Re: uSERNAME IN DB TRIGGERS.

    Originally posted by andrewst
    It should work OK. What error are you getting?
    Hi,
    As Andrewst suggested, the error is needed to identify the
    problem. But assuming that you are getting " table or view
    does not exist error".
    All you have to do is login to tom and give access to the emp table
    to scott.

    SQL>connect tom/password@db_name

    SQL> grant all on emp to scott;

    Hope it Helps.
    nn

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •