odbc_columnprivileges

    (PHP 4, PHP 5, PHP 7, PHP 8)

    odbc_columnprivileges — Lists columns and associated privileges for the given table

    Description

    odbc_columnprivileges(
        resource$odbc,
        ?string$catalog,
        string$schema,
        string$table,
        string$column
    ): resource|false

    Lists columns and associated privileges for the given table.

    Parameters

    odbc

    The ODBC connection identifier, see odbc_connect() for details.

    catalog

    The catalog ('qualifier' in ODBC 2 parlance).

    schema

    The schema ('owner' in ODBC 2 parlance). This parameter accepts the following search patterns: % to match zero or more characters, and _ to match a single character.

    table

    The table name. This parameter accepts the following search patterns: % to match zero or more characters, and _ to match a single character.

    column

    The column name. This parameter accepts the following search patterns: % to match zero or more characters, and _ to match a single character.

    Return Values

    Returns an ODBC result identifier or false on failure. This result identifier can be used to fetch a list of columns and associated privileges.

    The result set has the following columns:

    • TABLE_CAT
    • TABLE_SCHEM
    • TABLE_NAME
    • COLUMN_NAME
    • GRANTOR
    • GRANTEE
    • PRIVILEGE
    • IS_GRANTABLE
    Drivers can report additional columns.

    The result set is ordered by TABLE_CAT, TABLE_SCHEM, TABLE_NAME, COLUMN_NAME and PRIVILEGE.

    Examples

    Example #1 List Privileges for a Column

    <?php
    $conn     = odbc_connect($dsn, $user, $pass);
    $privileges = odbc_columnprivileges($conn, 'TutorialDB', 'dbo', 'test', 'id');
    while ((    $row = odbc_fetch_array($privileges))) {
    print_r($row);
    break;     // further rows omitted for brevity
    }
    ?>

    The above example will output something similar to:

    Array ( [TABLE_CAT] => TutorialDB [TABLE_SCHEM] => dbo [TABLE_NAME] => test [COLUMN_NAME] => id [GRANTOR] => dbo [GRANTEE] => dbo [PRIVILEGE] => INSERT [IS_GRANTABLE] => YES )
    To Top