Обсуждение: How can I create a database at a different path and not accessible by others

Поиск
Список
Период
Сортировка

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

От
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
SoftJin Technologies Pvt. Ltd.
#102, Mobius Tower, SJR I-Park, EPIP,
Whitefield, Bangalore 560066
Phone: +91-80-41779999
Fax: +91-80-41157070




Business Disclaimer
____________________________________________________________
This e-mail message and any files transmitted with it are intended solely
for  the use  of the  individual or entity  to which they  are  addressed. It
may  contain confidential,  proprietary or legally  privileged  information.
If  you  are  not  the  intended recipient please be advised that you have
received  this  message in error and any use is strictly prohibited. Please
immediately  delete it  and all copies of it from your system, destroy any
hard  copies  of  it and  notify  the  sender  by return mail. You must not,
directly or indirectly, use,  disclose,  distribute, print, or copy any part of
this message if you are not the intended recipient.
___________________________________________________________


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

От
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.