ODBC_SQLTablePrivileges

4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next

version 2004


ODBC_SQLTablePrivileges (stmtID; catalogName; schemaName; tableName) Longint

ParameterTypeDescription
stmtIDLongintStatement ID
catalogNameStringTable catalog name
schemaNameStringString search pattern for schema names
tableNameStringString search pattern for table names
Function resultLongintReturns the result of the MS ODBC API function
SQLTablePrivileges

Description

The ODBC_SQLTablePrivileges command returns a list of tables and the privileges associated with each table.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

catalogName is the table catalog name.

schemaName is the string search pattern for schema names.

tableName is the string search pattern for table names.

For more information, please see the SQLTablePrivileges function in the MS ODBC API at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqltableprivileges.asp.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

See Also

ODBC_SQLTables.


4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next