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

Example 1: User1 creates table1, and user2 creates view2 on 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 always access table1, since user1 is the owner.

• User1 can always access table1 through view2, since user1 is the owner of the underlying table. This is true even if user2 does not grant permission on view2 to user1.

• User2 can access table1 directly or through view2 if user1 grants permission on table1 to user2.

• User3 can access table1 if user1 grants permission on table1 to user3

• User3 can access table1 through view2 if user1 grants permission on table1 to user2 with grant option and user2 grants permission on view2 to user3.