Re: [GENERAL] How can I create a database at a different path and not accessible by others

2010-03-15 Thread John R Pierce
Rekha Ravi Pai wrote: Hi, I want to store confidential data. I created a user with createdb permission. How can I prevent others accessing tables created by this user? if you don't grant privileges to other roles or users, then only the table creator can access the created table. -- Sent

[GENERAL] How can I create a database at a different path and not accessible by others

2010-03-14 Thread Rekha Ravi Pai
Hi, I want to store confidential data. I created a user with createdb permission. How can I prevent others accessing tables created by this user? Regards, Rekha. -- Rekha Pai Senior Software Consultant