Example 2: User2 creates procedure2 that accesses table1

Contents

Index

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

ASA Database Administration Guide
Managing User IDs and Permissions
Changing Ownership on Nested Objects

Example 2: User2 creates procedure2 that accesses table1

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.

Contents

Index

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