Page 1 of 1
help with Postgresql - users and privileges
Posted: Sat Jul 12, 2025 1:11 pm
by mol
Hi!
I'm building an app, where I have a client registry in dbf file, but I need to create for everyone postgresql database.
I have to add users of application as users of postgresql.
It's simple, but my new created postgresql user has no rights to create tables in previously created db.
I granted privileges, but it still doesn't work.
I'm getting info about access denied to public schema
Re: help with Postgresql - users and privileges
Posted: Sat Jul 12, 2025 7:44 pm
by serge_girard
Marek,
Why should end-user have rights to create tables? Do you get some SQL errors?
Serge
Re: help with Postgresql - users and privileges
Posted: Sat Jul 12, 2025 7:49 pm
by mol
I thought that the database will be created by master user - then I switch to notmal user and create tables
My principal wants to log every steps done by his workers, but maybe my strategy was wrong?
Re: help with Postgresql - users and privileges
Posted: Sat Jul 12, 2025 8:03 pm
by serge_girard
Usually database and tables/indexes etc... are created by database admin. Users then will only have grants to update,insert and/or delete.
Maybe consider changing strategy.
But again, why should end-users create tables? Consider users with grant to create tables and then inserts lots of duplicates and data redundancy...
Re: help with Postgresql - users and privileges
Posted: Sun Jul 13, 2025 3:39 pm
by franco
Merek,
I have a large program designed by user. At the end of very entry line there is a pick box which runs a last emloyee listbox pick.
This setidn procedure has every employee in it. This is how he can keep track of emloyee entrys and create reports.
Code: Select all
@362, 10 something
@362,60 something
@ 362,435 BUTTON BUTTON_32C CAPTION "V" WIDTH 20 HEIGHT 20 action {{setidn('TEXT_32I')},{WIN_AC.TEXT_32I.SAVE}} tooltip 'Click to Change Initial'
There are some lines in the program that do not have emplyee picks.
Maybe something like this could work.