ODBCDatabase.ColumnPrivileges

From Xojo Documentation

You are currently browsing the old Xojo documentation site. Please visit the new Xojo documentation site!
Method

ODBCDatabase.ColumnPrivileges(TableName as String, ColumnName as Strings) As RowSet

Supported for all project types and targets.

Returns a RowSet with a list of columns and associated privileges for the specified table.

Notes

If the database supports multiple catalogs and schemas, then the RowSet will contain records for all catalogs and schemas that can be accessed by the logged in user that match the given table name.

The ColumnName is a search pattern for a column name of the given table. Use an empty string to match all columns in the table.

Microsoft provides additional information regarding ODBC column privileges.