DatabaseLink`
DatabaseLink`
SQLTablePrivileges
SQLTablePrivileges[conn]
returns a table of access rights about the tables in an SQL connection.
SQLTablePrivileges[conn,table]
returns access rights for table.
更多信息和选项
- To use SQLTablePrivileges, you first need to load DatabaseLink using Needs["DatabaseLink`"].
- The following options can be given:
-
范例
基本范例 (1)
If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseLink`DatabaseExamples` package, as described in Using the Example Databases.
Fetch privileges for all tables available on this connection: