Prerequisites

To create a view, log in as the owner of the schema that contains the view or as SUPER.SUPER user.

To alter, rename, and drop a view, log in as the owner of the view, the owner of the schema that contains the view, or as SUPER.SUPER user.

To grant privilege on a view, log in as the owner of the view, the security administrator, a user with grant privileges, or as SUPER.SUPER user if the Security Administrator group is empty.

To revoke privilege on a view, log in as the owner of the view, the security administrator, or as SUPER.SUPER user if the Security Administrator group is empty.