User`s guide

tableprivileges

7-237

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

resulting from a database connection object.

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 resulting from a database connection object.

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 resulting from a database connection object.

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'