Use the following matrix to understand what permission type allows access to databases, tables, and so on. For more information on how to assign policy-based database permissions, see Setting Policy-based Database Permissions in TD Console.
The following table shows the permissions matrix for policy-based database access control.
| Permission Type | Definition | Database Permissions |
|---|---|---|
| Not Configured | Users cannot view or access databases. | None |
| Full Access | Users have full access to all databases. |
|
Limited Access | Users can access databases with permissions for specific databases. | Specific database + one of the following permissions: |
Download | Users can download databases. | The user can
If the user does not have permission, they cannot download data from the database, and can only see 50 records of query results on the TD Console. In addition, job results are not available in TD Workflow like store_last_results:true of td>: operator and td_for_each>: operator. |
Manage Own | Users can create a database. The user is the database owner and can manage and delete the database. | The database owner can:
|
| General Access | Users can access a specific database and work with database tables. |
|
| Query-only | Users can only query the databases that the administrator has granted permission to. |
|
| Import-only | Users can create tables and import data to a database table. |
|
The following table compares the differences between legacy and policy-based database permissions.
| Database Permissions | Differences |
|---|---|
Legacy Database Permissions | Full Access
|
Policy-Based Database Permissions | Full Access
|