odbc_columnprivileges

Returns a result identifier that can be used to fetch a list of columns and associated privileges (PHP 4, PHP 5)
resource odbc_columnprivileges ( resource connection_id, string qualifier, string owner, string table_name, string column_name )

Lists columns and associated privileges for the given table. Returns an ODBC result identifier or FALSE on failure.

The result set has the following columns:

TABLE_QUALIFIER
TABLE_OWNER
TABLE_NAME
GRANTOR
GRANTEE
PRIVILEGE
IS_GRANTABLE

The result set is ordered by TABLE_QUALIFIER, TABLE_OWNER and TABLE_NAME.

The column_name argument accepts search patterns ('%' to match zero or more characters and '_' to match a single character).

Examples ( Source code ) » odbc_columnprivileges


<?php

    //connect to database

    $Link = odbc_connect("SQLServer-Local", "dbo", "secret");

    $Result = odbc_columnprivileges($Link, "Store", "dbo", "Items","%");



    //print results

    odbc_result_all($Result);



    //close connection

    odbc_close($Link);

?>

Change Language

odbc_autocommit
odbc_binmode
odbc_close_all
odbc_close
odbc_columnprivileges
odbc_columns
odbc_commit
odbc_connect
odbc_cursor
odbc_data_source
odbc_do
odbc_error
odbc_errormsg
odbc_exec
odbc_execute
odbc_fetch_array
odbc_fetch_into
odbc_fetch_object
odbc_fetch_row
odbc_field_len
odbc_field_name
odbc_field_num
odbc_field_precision
odbc_field_scale
odbc_field_type
odbc_foreignkeys
odbc_free_result
odbc_gettypeinfo
odbc_longreadlen
odbc_next_result
odbc_num_fields
odbc_num_rows
odbc_pconnect
odbc_prepare
odbc_primarykeys
odbc_procedurecolumns
odbc_procedures
odbc_result_all
odbc_result
odbc_rollback
odbc_setoption
odbc_specialcolumns
odbc_statistics
odbc_tableprivileges
odbc_tables

odbc_columnprivileges

Returns a result identifier that can be used to fetch a list of columns and associated privileges (PHP 4, PHP 5) resource odbc_columnprivileges ( resource connection_id, string qualifier, string owner, string table_name, string column_name )

Change Language

Returns a result identifier that can be used to fetch a list of columns and associated privileges (PHP 4, PHP 5)
resource odbc_columnprivileges ( resource connection_id, string qualifier, string owner, string table_name, string column_name )