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.

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 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 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 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'

Introduced before R2006a

Was this topic helpful?