Example 2: User2 creates procedure2 that accesses table1

Example 1: User1 creates table1, and user2 creates view2 on table1

Example 3: User1 creates table1, user2 creates table2, and user3 creates view3 joining table1 and table2

SQL Anywhere Studio Security Guide
Restrictions and Other Security Concerns
Changing ownership on nested objects

Example 2: User2 creates procedure2 that accesses table1

This page describes operation of Adaptive Server Anywhere in a manner equivalent to a C2-security-certified configuration. It does not provide general-purpose information on the topic.

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