Contents Index GRANT PUBLISH statement GRANT REMOTE DBA statement

SQL Remote User's Guide
  Command Reference for Adaptive Server Anywhere

GRANT REMOTE statement


Function 

Use this statement to identify a database immediately below the current database in a SQL Remote hierarchy, who will receive messages from the current database. These are called remote users.

Syntax 

GRANT REMOTE TO userid, ...
TYPE message-system, ...
ADDRESS address-string, ...
SEND { EVERY | AT } send-time ]

Parameters 
Parameter Description
userid The user ID for the user to be granted the permission
message-system One of the message systems supported by SQL Remote. It must be one of the following values:
  • FILE

  • FTP

  • MAPI

  • SMTP

  • VIM

address-string A string containing a valid address for the specified message system.
send-time A string containing a time specification in the form hh:mm.
Permissions 

Must have DBA authority.

Side effects 

Automatic commit.

See also 

GRANT REMOTE statement [SQL Remote]

GRANT CONSOLIDATE statement

REVOKE REMOTE statement

GRANT PUBLISH statement

sp_grant_remote procedure

Granting and revoking REMOTE and CONSOLIDATE permissions


Contents Index GRANT PUBLISH statement GRANT REMOTE DBA statement