Sybase Adaptive Server Anywhere - Page 614

REVOKE statement
596
♦
SQL/92 Syntax 1 is a vendor extension. Syntax 2 is an entry-level
feature. Syntax 3 is a Persistent Stored Module feature.
♦
Sybase Syntax 2 and 3 are supported by Adaptive Server Enterprise.
Syntax 1 is not supported by Adaptive Server Enterprise. User
management and security models are different for Adaptive Server
Anywhere and Adaptive Server Enterprise.
♦ Prevent user Dave from updating the employee table.
REVOKE UPDATE ON employee FROM dave;
♦ Revoke resource permissions from user Jim.
REVOKE RESOURCE FROM Jim;
♦ Revoke integrated login mapping from user profile name Administrator
REVOKE INTEGRATED LOGIN FROM Administrator;
♦ Disallow the Finance group from executing the procedure
sp_customer_list.
REVOKE EXECUTE ON sp_customer_list
FROM finance;
♦ Drop user ID FranW from the database.
REVOKE CONNECT FROM FranW
Standards and
compatibility
Examples