apsavin/pgrights

GUI for PostgreSQL roles, privileges and policies

pgrights

GUI for PostgreSQL roles, privileges and policies

How to run

Download dmg file from the latest release

or build from source:

yarn && yarn package

RoadMap and changelog

• 1.0.0
  • SQL commands log
  • Possibility to delete connections
  • Possibility to delete policies
• 0.2.0
  • Possibility to edit table and column access
  • View for single policy with SQL syntax highlighting
  • Possibility to edit policies
• 0.1.0 Readonly version
  • Create and edit database connections
  • Possibility to select a schema
  • Possibility to filter and select a table
  • Possibility to filter and select a role
  • View for table and colunm access
  • View for row-level policies

pgrights's Issues

Make filters smarter

How to reproduce

1. Consider you have a table name in camel case, like siteDomains
2. You need to filter out other tables and you remember, that needed table contains domains. You type into filter domain

What's expected?

You see siteDomains table

Actual result

You see nothing, since filter is case sensitive

Highlight tables which are available for selected role

The case

You have lot of tables, but some role has access to only several tables. On right side you click by this role's name.

Desired behaviour

In the left panel, all tables which user has some rights for have black color and are at the top. All other tables are greyed out and located at the bottom. Like this:

Can't see permissions for postgres user

How to reproduce

1. Create a new connection using postgres user
2. Connect and try to see permissions for any table

Expected result

Everything is allows

Actual result

No rights for any table

column a.rolbypassrls does not exist

macOS 10.14

Running both the packaged version and the development version

MonacoWebpackPlugin version issue

env = win10, node=13.7.0

run flow : npm run build-dll

error message : Error: Cannot find module 'monaco-editor\esm\vs\editor\contrib\gotoSymbol\goToCommands'

after tracing, the monaco-editor-webpack-plugin package is removed the related feature gotoSymbol

suggestion :

ignore the issue by adding features: ['!gotoSymbol'], if there are no dependence on the feature.

@webpack.config.base.js , line42~48

 plugins: [
    new MonacoWebpackPlugin({
      // available options are documented at https://github.com/Microsoft/monaco-editor-webpack-plugin#options
      languages: ['pgsql'],
      features: ['!gotoSymbol'], // <<- add this
    }),
  ]

OS Support

What OSes does this software support currently? Some details about this in the README would be appreciated.