Understanding permissions

In SQL Anywhere, permissions allow users to access, create, modify, and delete database objects (tables, views, procedures, and so on). For example, to select data from a table, the user must either own the table, or have SELECT permissions on it.

A user's permissions can be grouped into the following main categories:

  • Permissions explicitly set for the user or group   These are the permissions that are explicitly set for a user or group to control whether they can create, modify, execute, or delete database objects.

  • Permissions acquired through ownership of an object   These are the permissions acquired by virtue of creating a data base object. For example, if a user creates a table, their ownership allows them to modify or delete the object.

  • Permissions inherited through group membership   These are the permissions inherited from a group to which a user or group belongs.

  • Permissions on disabled objects   You can grant permissions on disabled objects. Permissions to disabled objects are stored in the database and become effective when the object is enabled.


Permissions explicitly set for the user or group
Permissions acquired through ownership of an object
Permissions inherited through group membership