SQLTablePrivileges

SQLTablePrivileges[conn]
returns a table of access rights about the tables in an SQL connection.

DetailsDetails

  • To use SQLTablePrivileges, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • The following options can be given:
  • "Catalog"Nonedatabase catalog to use
    "Schema"Nonedatabase schema to use
    "ShowColumnHeadings"Nonewhether to return headings with the results
New to Mathematica? Find your learning path »
Have a question? Ask support »