help with Postgresql - users and privileges

[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

[serge_girard]

Marek,

Why should end-user have rights to create tables? Do you get some SQL errors?

Serge

[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?

[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...

[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.