tableprivileges - Return 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 a list of table privileges for all tables in the catalog cata for the database whose database metadata object is dbmeta.

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

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

Examples

Get table privileges for the builds table in the schema geck for the catalog msdb, for the database metadata object dbmeta.

tp = tableprivileges(dbmeta,'msdb','geck', 'builds')
tp = 
      'DELETE'    'INSERT'    'REFERENCES' ...
	     'SELECT'    'UPDATE'

See Also

dmd | get | tables

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