DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: granting to a trigger

  1. #1
    Join Date
    Apr 2003
    Location
    Malaysia
    Posts
    2

    granting to a trigger

    i'm already granting privilege to a user to create triggerin our database. But when we run the trigger, we got error : table or view does nt exists.

    Before this, we also grant select, insert, update, delete to that user.

    Plz anybody help me. urgent.

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    hi

    Hi

    include tableowner.tablename
    ex.
    select * from tableowner.tablename;

    Thomas
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97
    its trigger it brings up to date another table? if yes, you also need Grant for the other table.
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br

Posting Permissions

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


Click Here to Expand Forum to Full Width