Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements » Alphabetical list of SQL statements

GRANT INTEGRATED LOGIN statement

Grants a user privilege to execute a procedure or user-defined function.

Syntax
GRANT INTEGRATED LOGIN TO user-profile-name, ... 
[ AS USER userid ]
Remarks

The GRANT INTEGRATED LOGIN statement creates an explicit integrated login mapping between one or more Windows user or group profiles and an existing database user ID, allowing users who successfully log in to their local computer to connect to a database without having to provide a user ID or password. The user-profile-name can be of the form domain\user-name. The database user ID the integrated login is mapped to must have a password.

Privileges

You must have the MANAGE ANY USER system privilege.

Side effects

Automatic commit.

Standards
  • ANSI/ISO SQL Standard

    Not in the standard.