Since system procedures are located in the sybsystemprocs database, their permissions are also set there. Some system procedures can be run only by Database Owners. These procedures ensure that the user executing the procedure is the owner of the database on which they are executed.
Other system procedures can be executed by any user who has been granted execute permission on them, but this permission must be granted in the sybsystemprocs database. This situation has two consequences:
A user can have permission to execute a system procedure either in all databases or in none of them.
The owner of a user database cannot directly control permissions on the system procedures within his or her own database.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
