Examples of granting object access permissions

This statement gives Mary and the “sales” group permission to insert into and delete from the titles table:

grant insert, delete 
on titles 
to mary, sales

This statement gives Harold permission to use the stored procedure makelist:

grant execute
on makelist
to harold

This statement grants permission to execute the custom stored procedure sa_only_proc to users who have been granted the System Administrator role:

grant execute
on sa_only_proc
to sa_role

This statement gives Aubrey permission to select, update, and delete from the authors table and to grant the same permissions to other users:

grant select, update, delete 
on authors
to aubrey
with grant option

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF