Sybase Adaptive Server Anywhere - Page 561

Chapter 9 SQL Statements
543
♦
SQL/92 Syntax 3 is an entry-level feature. Syntax 4 is a Persistent
Stored Module feature. Other syntaxes are vendor extensions.
♦
Sybase Syntaxes 2 and 3 are supported in Adaptive Server Enterprise.
The security model is different in Adaptive Server Enterprise and
Adaptive Server Anywhere, so other syntaxes differ.
♦ Make two new users for the database.
GRANT
CONNECT TO Laurel, Hardy
IDENTIFIED BY Stan, Ollie
♦ Grant permissions on the employee table to user Laurel.
GRANT
SELECT, UPDATE ( street )
ON employee
TO Laurel
More than one permission can be granted in a single statement. Separate
the permissions with commas.
♦ Allow the user Hardy to execute the
Calculate_Report procedure.
GRANT
EXECUTE ON Calculate_Report
TO Hardy
Standards and
compatibility
Examples