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.
Contexte et remarques
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;
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0|