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

Thread: Privileges to see triggers

  1. #1
    Join Date
    Dec 1999
    Posts
    217

    Privileges to see triggers

    WHat privileges does the user need to have so that he can see the triggers in another users schema?

    Appreciate your input.

    -Chintz

  2. #2
    Join Date
    Dec 1999
    Posts
    217
    The user has select, insert, update and delete on the other schemas tables. SHouldn't he be able to see the triggers when he logs in?

    -Chintz

  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,
    i think the syspriv CREATE ANY TRIGGER
    Orca

  4. #4
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Originally posted by Chintz
    The user has select, insert, update and delete on the other schemas tables. SHouldn't he be able to see the triggers when he logs in?

    -Chintz
    Triggers are procedural objects and have nothing to do with the Object-privieleges of the table
    Orca

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