Documentation Center

  • Trial Software
  • Product Updates

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'

See Also

| | | |

Was this topic helpful?