Dear group, i created a user named 'dataviewer' and grant only select permission to that user, but now the user could able to create tables. how to restrict this, i want to give permission to create views and do selects on tables and views.
how to do it? plz help.-- Sathish Kumar.SSpireT
Dear group
Its my mistake that i did not reveal the whole scenario. Actually within that begin and commit, i insert in 10 tables. The above said table is the key table. I fetch the consultatioin_no and add one to it, i should know this consultation_no to save the other 10 tables. because
faced the problem, then we run in three system the record is saved, after that we simulate the run once again, we face the problem,
i could not predict the problem precisely - what might be the problem. thanks in advance- Show quoted text -
On 6/16/06, Richard Huxton <dev@archonet.c
Dear group, Let me explain my issue. We use Database - postgresql-8.1 JDBC Driver - postgresql-8.1-407.jdbc3.jar Java - jdk1.5 The default transaction isolation level is - Read Committed
Auto Commit is fals
