Database Toolbox™

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

  • 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

supports

tables