Database Toolbox

tableprivileges

Get database table privileges

Syntax

tp = tableprivileges(dbmeta, 'cata')
tp = tableprivileges(dbmeta, 'cata', 'sch')
tp = tableprivileges(dbmeta, 'cata', 'sch', 'tab')

Description

tp = tableprivileges(dbmeta, 'cata') returns the list of table privileges for all tables in the catalog cata, for the database whose database metadata object is dbmeta, where dbmeta was created using dmd.

tp = tableprivileges(dbmeta, 'cata', 'sch') returns the list of table privileges for all tables in the schema sch, of the catalog cata, for the database whose database metadata object is dbmeta, where dbmeta was created using dmd.

tp = tableprivileges(dbmeta, 'cata', 'sch', 'tab') returns the list of privileges for the table tab, in the schema sch, of the catalog cata, for the database whose database metadata object is dbmeta, where dbmeta was created using dmd.

Examples

Type

tp = tableprivileges(dbmeta,'msdb','geck', 'builds')

MATLAB returns

tp = 
      'DELETE'    'INSERT'    'REFERENCES'    'SELECT'    'UPDATE'

In this example:

• dbmeta is the database metadata object
• msdb is the catalog cata
• geck is the schema sch
• builds is the table tab.

The results show the set of privileges.

See Also
dmd, get, tables

supports

tables