I am not an expert in postgres, may this work for you.
REVKE INSERT,UPDATE,DELETE N ALL from PUBLIC;
it will take the INSERT,UPDATE,DELETE permmission from all users for all
objects in the database.
If you want to give permission for a specific user on all objects
GRANT ALL on ALL to <user_name>;
Please make a backup before doing this , good for always
I am not sure is this is want you want.
7/4/06, Penchalaiah P. <penchalaiahp (AT) infics (DOT) comwrote:
I have 290 tables to these tables one schema is there that name is
public.so I don't know how to create permission to these tables either I
have to give permissions to individual table or I have to give permissions
to schema or schema name if I give permission to schema it has to
applicable to all tables
I created one user with password then finally I don't know how to
allocate permission to him please tell me very briefly step by step then
I can understand
Please tell me if any one knows about this
way to limit which users can access specific database is with the pg_hba.conf file.
You really should spend some time to read it.
#AUTH-PG-HBA-CNF
In PostgreSQL 8.1 the concept of "Roles" were added. A "Role" can be given specific privileges to
the database. this step is complete, database uses can be assigned to this role. This will
essentially inherit all role privileges to these users. There is also an important document that
should be read in order to understand it.
The SQL syntax for assigning privileges is found here:
Also finding these topic is very easy also. Simple scan over the table of contents of the manual:
And of-course depending on what version of PostgreSQL you have:
Regards,
Richard Broersma Jr.
(end of broadcast)
TIP 5: don't forget to increase your free space map settings