Example 2: User2 creates procedure2 that accesses table1

  • User1 can access table1 through procedure2 if user2 grants EXECUTE permission on procedure2 to user1. This is different from the case of view2, where user1 did not need permission on view2.