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
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |