By default, the database automatically grants logon permission to all users defined in the database, from all client system connections (hostids).
You only need to grant the logon privilege to a user if you:
- First revoke the logon privilege
- Want to specify an extension of logon privileges to GRANT LOGON ... WITH NULL PASSWORD, to allow the user to be externally authenticated.
- Want to specify user logons through a host ID or list of host IDs.