search

ForumPostAssistant / FPA

The Forum Post Assistant (FPA) script has been developed to assist Joomla!® forum posters to be able to post relevant system, instance, PHP and troubleshooting information directly in to a pre-formatted forum post. This will save a few hours of posting back and forth, asking for, and explaining how to acquire useful information in order for other forum users to help troubleshoot a problem.
https://forumpostassistant.github.io/docs/
GNU General Public License v2.0
25 stars 15 forks source link

Add database user privileges to postgres checks #69

Closed RussW closed 2 years ago

RussW commented 4 years ago

The database user privs have been added to mysql, mysqli & mysqlPDO but not to postgres yet

frostmakk commented 4 years ago

@RussW PostgreSQL is quite a different beast than MySQL. There seems to be customizable privileges for every nut & bolt in the database. I'm struggling with picking out the few we need to determine if the user has sufficient privileges. There are two system tables we can query that could be used: image or image

Of course if the user is a super user, there is no need to look further, but what other roles/privileges/combinations in the tables do you think should be considered?

RussW commented 4 years ago

Yes, I had a quick look and saw that. Maybe once we get the current branch released, you and I can do some further research in to the postgres "roles" and "grants" and determine if we can do the same or similar as with mysql(i/PDO)

It looks like we need to query the users role first, then find the grants assigned to the role after.

frostmakk commented 3 years ago

First attempt at presenting sufficient database-user privileges for PostgreSQL. Check out branch PostgreSQL-User-Privileges.

RussW commented 3 years ago

apologies for the delay in responding @frostmakk, this is on my list to test in the next week or so, speak more then but looks great at the moment, great work

frostmakk commented 2 years ago

Included in v1.6.3