Does either of the following:
- Revokes permission to log on to the database from one or more specific client systems.
- Changes the current system logon defaults.
See GRANT LOGON for information about granting logon privileges.
Required Privileges
You must have the EXECUTE privilege on the DBC.LogonRule macro to perform REVOKE LOGON.
No checks are made on whether the database names or user names defined in the statement apply to users owned by the requesting user.
If the system cannot verify the submitted statement because it specifies a nonvalid user name or a nonvalid host ID, then an error is returned.
Syntax
REVOKE LOGON ON { host_id [,...] | ALL } { AS DEFAULT | { TO | FROM } user_name [,...] } [;]
Syntax Elements
- host_id
- An integer that identifies a mainframe connection or a workstation connection that is currently defined to the system by the hardware configuration data. The interface need not be operational.
- ALL
- Any source through which a logon is attempted, including the database console.
- AS DEFAULT
- Indicates that the current default for the specified host ID set is to be changed, without residual conditions, as defined in this REVOKE LOGON request.
- TO
- FROM
- Keywords introduced to override the current default for the specified database_name_list or user_name set on the specified host_ID set.
- user_name
- One or more user names from whom logons are to be revoked.