User`s guide

columnprivileges

7-19

columnprivileges

List database column privileges

Syntax

lp = columnprivileges(dbmeta,'cata','sch','tab')

lp = columnprivileges(dbmeta,'cata','sch','tab','l')

Description

lp = columnprivileges(dbmeta,'cata','sch','tab') returns a list of privileges

for all columns in the table tab, in the schema sch, in the catalog cata for the database

whose database metadata object is dbmeta.

lp = columnprivileges(dbmeta,'cata','sch','tab','l') returns a list of

privileges for column l in the table tab, in the schema sch, in the catalog cata for the

database whose database metadata object is dbmeta.

Examples

Return a list of privileges for the given database, catalog, schema, table, and column

name:

lp = columnprivileges(dbmeta,'msdb','geck','builds',...

'build_id')

lp =

'builds' 'build_id' {1x4 cell}

View the contents of the third column in lp:

lp{1,3}

ans =

'INSERT' 'REFERENCES' 'SELECT' 'UPDATE'