Explore, Analyze & Document
Visual Expert System Requirements
Trial / Small Project
- Repository Storage:
SQL Server Local DB* - CPU: 4 cores minimum
- RAM: 4 GB Minimum
- Hard Drive: 10 GB Minimum
- OS: Windows 8, Windows 10, Windows 11
Standalone
- Repository Storage:
SQL Server: Developer (Free), Enterprise, Standard, or Web (Express not supported) - CPU: 4 cores minimum - 3 Ghz or higher
- RAM: 8 GB Minimum
- Hard Drive: 100 to 256 GB
- OS: Windows 8, Windows 10, Windows 11
Concurrent / Large Projects
Server Side
- Repository Storage:
SQL Server: Developer (Free), Enterprise, Standard, or Web (Express not supported)
SQL Version: 2012, 2016, 2019, 2022 - OS: Windows Server 2012, 2016, 2019, 2022
Less than 1 GB of code
- RAM: 16 GB Minimum
- Hard Drive: 512 GB to 1 TB
- CPU: 8 cores minimum - 3 Ghz or higher
More than 1 GB of code
- RAM: 64 GB Ram
- Hard Drive: 1 TB with 500 GB free space
- CPU: 4 Cores with 12 Virtual Cores - 3 Ghz or higher
Client Side
- CPU: 4 cores minimum
- RAM: 4 GB Minimum
- OS: Windows 8, Windows 10, Windows 11
Required Permissions:
- SELECT ANY DICTIONARY
- SELECT ANY TABLE
- UNLIMITED TABLESPACE
- GLOBAL QUERY REWRITE
- CREATE MATERIALIZED VIEW
Required Role:
- SELECT_CATALOG_ROLE
or - AQ_ADMINISTRATOR_ROLE
or - DBA
To check user permissions, you can use this query:
- SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE = '<user>';
To grant the required permissions to a user, you can use this query:
- GRANT SELECT ANY TABLE, SELECT ANY DICTIONARY , UNLIMITED TABLESPACE to {0};
To grant a required role to a user, you can use this query:
- GRANT SELECT_CATALOG_ROLE to '<user>';