Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » User and database security » User security (roles and privileges) » Ownership of nested objects

 

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

  • User3 can access table1 and table2 through view3 if user1 grants privilege on table1 to user3 and user2 grants privilege on table2 to user3.

  • If user3 has privilege on table1 but not on table2, then user3 cannot use view3, even to access the subset of columns belonging to table1.

  • User1 or user2 can use view3 if (a) user1 grants privilege with grant option on table1 to user3, (b) user2 grants privilege with grant option on table2 to user3, and (c) user3 grants privilege on view3 to that user.