A user with DBA authority or the owner of the procedure may grant permission to execute stored procedures. The EXECUTE permission is the only permission that may be granted on a procedure.
The method for granting permissions to execute a procedure is similar to that for granting permissions on tables and views. However, the WITH GRANT OPTION clause of the GRANT statement does not apply to the granting of permissions on procedures.
You can use either Sybase Central or Interactive SQL to set permissions.
To grant permissions on procedures (Sybase Central)
Connect to the database as a user with DBA authority.
Click Procedures & Functions.
Right-click a procedure and then choose Properties.
Click the Permissions tab.
Configure the permissions for the procedure:
You can also assign permissions from the User Properties or Group Properties window. Use the Procedure Properties window to assign permissions to multiple users or groups. Use the User Properties or Group Properties window to assign permissions to multiple procedures.
To grant permissions on procedures (SQL)
Connect to the database as a user with DBA authority or as the owner of the procedure.
Execute a GRANT EXECUTE ON statement.
You can grant M_Haneef permission to execute a procedure named my_procedure, as follows:
GRANT EXECUTE ON my_procedure TO M_Haneef;
Procedures execute with the permissions of their owner. Any procedure that updates information in a table will execute successfully only if the owner of the procedure has UPDATE permissions on the table.
As long as the procedure owner has the proper permissions, the procedure executes successfully when called by any user assigned permission to execute it, whether or not they have permissions on the underlying table. You can use procedures to allow users to perform well-defined activities on a table, without having any general permissions on the table.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|