Connect PrestoDB

-- PrestoDB user authentication depends on your setup:
-- 
-- For file-based authentication:
-- 1. Edit etc/password.properties
-- 2. Add: unitylayer_user=your_secure_password
-- 
-- For LDAP authentication:
-- Ensure your LDAP server has a user 'unitylayer_user'
-- 
-- For other authentication methods, refer to PrestoDB documentation

-- Grant access to catalogs (connectors)
-- This is typically configured in PrestoDB's catalog configuration
-- 
-- Example for Hive catalog:
-- In etc/catalog/hive.properties, ensure proper permissions
-- 
-- For system catalog:
GRANT SELECT ON system.runtime.queries TO unitylayer_user;

-- Grant access to schemas in your catalog
-- Example for Hive catalog:
GRANT SELECT ON hive.your_schema.* TO unitylayer_user;
-- 
-- Or for all schemas in a catalog:
GRANT SELECT ON hive.*.* TO unitylayer_user;

-- Grant read access to specific tables
GRANT SELECT ON hive.your_schema.your_table TO unitylayer_user;
-- 
-- Or for all tables in a schema:
GRANT SELECT ON hive.your_schema.* TO unitylayer_user;

-- Test connection with PrestoDB CLI or client:
-- presto --server localhost:8080 --user unitylayer_user --catalog hive --schema your_schema
-- 
-- Or verify permissions:
SHOW GRANTS FOR unitylayer_user;