You can use the GRANT LOGON or REVOKE LOGON statement to enable or disable:
- All logons to the database for a particular user
- Logons to the database by a user through one or more host IDs. For information on setting up host groups, see Restricting Logons by Host Group.
For example:
[GRANT|REVOKE] LOGON ON hostid FROM username
where:
-
hostid can be:
- A single hostid
- A comma-separated list of hostids
- ALL
-
username can be a:
- Vantage username
- Comma-separated list of user names
A REVOKE LOGON statement affects only future logon attempts. It does not affect currently logged on users. You can restore logon privileges with the GRANT LOGON statement.