Database Toolbox™

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

1. Use columnprivileges, passing in the following arguments:

   • The database metadata object.dbmeta

   • The catalog msdb

   • The schema geck

   • The table builds

   • The column name build_id

   lp = columnprivileges(dbmeta,'msdb','geck','builds',...
   'build_id')
   lp =
        'builds'    'build_id'    {1x4 cell}
   

   This result shows:

   • The table name, builds, in column 1

   • The column name, build_id, in column 2

   • The column privileges, lp, in column 3

2. View the contents of the third column in lp.

   lp{1,3}
   ans =
        'INSERT'    'REFERENCES'    'SELECT'    'UPDATE'
   

See Also

cols, columns, columnnames, dmd, get

columnnames

columns