REVOKE (Execute Privileges)
Revokes
privileges granted on executable database objects from a user.
SYNTAX
| executable_name |
Name
of the executable object you want to revoke execute privileges on. |
| user_name |
Name
of the user you want to revoke execute privileges from. |
| group_name |
Name
of the group you want to revoke execute privileges from. |
DESCRIPTION
The REVOKE
(execute privileges) command revokes execute privileges on executable
database objects from individual users or groups. To execute the REVOKE
(execute privileges) command, you must be the object owner, or have DBA
or SYSADM security privileges.
Execute
privileges control which executable database objects a user can use. DBMaker
has three types of executable objects: stored commands, stored procedures,
and projects.
The COMMAND
keyword specifies that the object you are revoking EXECUTE privileges
on is a stored command. To execute a stored command, you must have all
security and object privileges necessary to execute the SQL statement
that makes up the stored command in addition to having EXECUTE privilege
on the command.
The PROCEDURE
keyword specifies that the object you are revoking EXECUTE privileges
on is a stored procedure. You do not need any additional security or object
privileges to execute the stored procedure if you have EXECUTE privilege
on the stored procedure.
The PROJECT
keyword specifies that the object you are revoking EXECUTE privileges
on is a project containing one or more stored procedures. Revoking EXECUTE
privileges on a project automatically revokes EXECUTE privileges on all
procedures in that project.
The user
who creates an executable database object is the owner of that object.
The owner and any user with DBA or SYSADM security privileges automatically
have EXECUTE privileges on that object. It is possible to revoke EXECUTE
privilege from all users simultaneously by revoking the privilege from
PUBLIC. All current users will lose EXECUTE privilege on the executable
database object.
EXAMPLES
The following
example revokes EXECUTE privilege on the stored command named ListUserTables
from the user named Vivian.
REVOKE EXECUTE ON COMMAND ListUserTables FROM Vivian
|
The following
example revokes EXECUTE privilege on the stored procedure named ShowUsers
from the users named Jenny and John, and the group Managers.
REVOKE EXECUTE ON PROCEDURE ShowUsers FROM Jenny, John, Managers
|
The
following example revokes EXECUTE privileges on all stored procedures
in the InternetFunc from all present and future users using the PUBLIC
keyword.
REVOKE EXECUTE ON PROJECT InternetFunc FROM PUBLIC
|
RELATED COMMANDS
<
REMOVE FROM GROUP | Contents
| REVOKE (Object Privileges) >
|
