Write SQL for a matching login
matching_login_sqlGenerate setup SQL for a read-only Postgres or Snowflake login limited to rows and columns granted by a connection's applied profiles; run it as user or DBA so the DB hides ungranted data.
Instructions
Write setup SQL for a read-only database login that can read exactly what a connection's applied profiles grant (Postgres or Snowflake), for the user or their DBA to run, so the database itself hides what isn't granted. login names a new login (default portward_); current_login tightens the login the connection uses now instead. The SQL has a placeholder where the password or key goes; Portward doesn't keep it.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"source": "<source>"
},
"name": "matching_login_sql"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| login | No | ||
| source | Yes | ||
| current_login | No |