Grant object-level privileges to allow access to a specific object, such as a table, view, procedure, sequence, or dbspace. You can view and change privileges either per user, role, or database object.
To grant an object-level privilege, one of the following must be true:
You are the owner of the database object you are granting privileges for.
You have been granted the privilege and have administrative rights on it.
You have the MANAGE ANY OBJECT PRIVILEGE system privilege.
Context and remarks
When you grant privileges to roles, they are inherited by the members of the role.
Connect to the database.
Execute a GRANT statement.
The following statement grants SELECT privilege on table myTable to user AnnW:
GRANT SELECT ON myTable TO AnnW;
The following statement grants SELECT privilege on table myTable to user AnnW, and gives her administrative rights for the privilege:
GRANT SELECT ON myTable TO AnnW WITH GRANT OPTION;
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|