columnprivileges - List database column privileges

Syntax

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'

See Also

cols | columnnames | columns | dmd | get

© 1984-2012- The MathWorks, Inc.    -   Site Help   -   Patents   -   Trademarks   -   Privacy Policy   -   Preventing Piracy   -   RSS