4D Doc Center : ODBC_SQLTablePrivileges

Home

4D v14.1

ODBC_SQLTablePrivileges


ODBC_SQLTablePrivileges ( stmtID ; catalogName ; schemaName ; tableName ) -> Function result

Parameter	Type	Description
stmtID	Longint	Statement ID
catalogName	String	Table catalog name
schemaName	String	String search pattern for schema names
tableName	String	String search pattern for table names
Function result	Longint	Returns the result of the MS ODBC API function SQLTablePrivileges

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 Reference at http://msdn.microsoft.com/en-us/library/ms713565(VS.85).aspx.

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.