Documentation

This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.

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'

Introduced before R2006a

Was this topic helpful?