From Xojo Documentation


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

Supported for all project types and targets.

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


If the database supports multiple catalogs and schemas, then the RecordSet 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.


SQLColumnPrivileges ODBC function