-
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
-
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
-
Hi,
i think the syspriv CREATE ANY TRIGGER
Orca
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|