cube-js / cube-js/cube

How to set role for my sql query, if my source database uses row-level security based on role?

Open
#7,873 1 comment 0 reactions 0 assignees View on GitHub
question
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

Description

**Problem**

How to set role for my sql query, if my source database uses row-level security based on role?

**Related Cube.js schema**
```javascript
cube(`Cube`, {
sql:
`
SET ROLE = test_role_1;
SELECT oid, count, created FROM test_table_1;
`
})
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.