ODBCDatabase.ColumnPrivileges

From Xojo Documentation

Method

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

Supported for all project types and targets.

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

Notes

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.

References

SQLColumnPrivileges ODBC function