version 2004
ODBC_SQLTablePrivileges (stmtID; catalogName; schemaName; tableName) Longint
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 |
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