Skip to content

Postgres: run scripts as a non-superuser to check if they can do something silly #53

@max-ieremenko

Description

@max-ieremenko

It is related to the discussion in the PR #50.

Created by @parmcoder

Use-case

Somehow, I want to be able to run some scripts as a non-superuser to check if they can do something silly.
Not sure if I did that correctly, I wrote something like SqlDatabase -database='Host=localhost;Username=myuser;Password=qwerty; Database=MyDatabase' -fromSql='SQL' [command].

Problem

I technically wanna quickly create a database from a new cluster and run some scripts using myuser, but it will instead log me into the myuser database.
That database exists because I used your script to create it at first. Then, when I try to create new databases using another user, it breaks.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions