PostgreSQL user listing

User aren’t actually, “for the database”, they’re for cluster and are given different permissions to access databases. To list users \du should do, but you need to be connected. Something like psql template1 -c ‘\du’ from the command line prompt should do. (or \du from psql prompt when you are connected to the database).

Execute Immediate within a stored procedure keeps giving insufficient priviliges error

Oracle’s security model is such that when executing dynamic SQL using Execute Immediate (inside the context of a PL/SQL block or procedure), the user does not have privileges to objects or commands that are granted via role membership. Your user likely has “DBA” role or something similar. You must explicitly grant “drop table” permissions to …

Read more

Privileges/owner issue when writing in C:\ProgramData\

No, C:\ProgramData, aka FOLDERID_ProgramData, has restricted security settings. Standard users can create files there. But these files are, by default, secured so that only the user that created the file can subsequently modify the file. The recommended solution is for your installer to create a sub directory of C:\ProgramData for your shared storage. And that …

Read more

Privileges/owner issue when writing in C:\ProgramData\

No, C:\ProgramData, aka FOLDERID_ProgramData, has restricted security settings. Standard users can create files there. But these files are, by default, secured so that only the user that created the file can subsequently modify the file. The recommended solution is for your installer to create a sub directory of C:\ProgramData for your shared storage. And that …

Read more