Обсуждение: Users specific to a Database

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

Users specific to a Database

От
"Sahoo, Ranjan Rashmi"
Дата:
<div class="Section1"><p class="MsoNormal"><font color="blue" face="Bookman Old Style" size="2"><span
style="font-size:10.0pt;font-family:"BookmanOld Style";color:blue">Hi All,</span></font><p class="MsoNormal"><font
color="blue"face="Bookman Old Style" size="2"><span style="font-size:10.0pt;font-family:"Bookman Old
Style";color:blue"> </span></font><pclass="MsoNormal"><font color="blue" face="Bookman Old Style" size="2"><span
style="font-size:10.0pt;font-family:"BookmanOld Style";color:blue">    I am new to this postgres and now struggling
withcreation of a user specific to a database, so the user can login to that specific database and can do the
activitiesas per the given credentials and can not touch or see any information from other databases. Can any one
pleasehelp me in this regard? </span></font><p class="MsoNormal"><font color="blue" face="Bookman Old Style"
size="2"><spanstyle="font-size:10.0pt;font-family:"Bookman Old Style";color:blue"> </span></font><p
class="MsoNormal"><fontcolor="blue" face="Bookman Old Style" size="2"><span
style="font-size:10.0pt;font-family:"BookmanOld Style";color:blue">I really appreciate for the help in advance.
 </span></font><pclass="MsoNormal"><strong><b><font color="#993300" face="Wingdings" size="6"><span
style="font-size:24.0pt;font-family:Wingdings;color:#993300">?</span></font></b></strong><b><fontcolor="blue"
face="Arial"size="2"><span style="font-size:10.0pt;font-family:Arial; 
color:blue;font-weight:bold">Thanks and Regards</span></font></b><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:12.0pt"><strong><b><font color="blue" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:blue">RanjanRashmi sahoo</span></font></b></strong><b><font
color="blue"face="Arial"><span style="font-family:Arial;color:blue;font-weight: 
bold"> |</span></font></b><b><font color="blue" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:blue;font-weight:bold"> UGSIOSDB Team</span></font></b><p
class="MsoNormal"style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; 
line-height:12.0pt"><font color="#3b3b3b" face="Arial" size="1"><span
style="font-size:7.5pt;font-family:Arial;color:#3B3B3B">UnisysGlobal Services India</span></font><font color="#3b3b3b"
face="Arial"><spanstyle="font-family:Arial;color:#3B3B3B"> | </span></font><font color="navy" face="Verdana"
size="1"><spanstyle="font-size:7.0pt;font-family:Verdana; 
color:navy">4F-361 SJR I-Park </span></font><font color="#3b3b3b" face="Arial"><span
style="font-family:Arial;color:#3B3B3B">|</span></font><font color="navy" face="Verdana" size="1"><span
style="font-size:7.0pt;font-family:Verdana;color:navy">WhitefieldRoad</span></font><font color="navy" face="Verdana"
size="1"><spanstyle="font-size:7.0pt;font-family:Verdana;color:navy">, Bangalore</span></font><font color="navy"
face="Verdana"size="1"><span style="font-size:7.0pt;font-family:Verdana; 
color:navy"> 560066</span></font><font color="#3b3b3b" face="Verdana" size="1"><span
style="font-size:7.0pt;font-family:Verdana;color:#3B3B3B"> </span></font><fontcolor="#3b3b3b" face="Arial"><span
style="font-family:Arial;color:#3B3B3B">|</span></font><fontcolor="#3b3b3b" face="Arial" size="1"><span
style="font-size:7.5pt;font-family:
Arial;color:#3B3B3B"> Phone +91804032-3322 </span></font><font color="#3b3b3b" face="Arial"><span
style="font-family:Arial;color:#3B3B3B">|</span></font><fontcolor="#3b3b3b" face="Arial" size="1"><span
style="font-size:7.5pt;font-family:
Arial;color:#3B3B3B"> Mobile +91-9449251441 </span></font><font color="#3b3b3b" face="Arial"><span
style="font-family:Arial;color:#3B3B3B">|</span></font><fontcolor="#3b3b3b" face="Arial" size="1"><span
style="font-size:7.5pt;font-family:
Arial;color:#3B3B3B"> Net 757-3322</span></font><font color="#3b3b3b" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:#3B3B3B"><img height="17" id="_x0000_i1025"
src="cid:image002.jpg@01C7A20F.E01ACB50"width="67" /></span></font><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:12.0pt"><font color="#9d9282" face="Arial" size="1"><span
style="font-size:7.5pt;font-family:Arial;color:#9D9282">THISCOMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE
PROPRIETARYMATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact
thesender and delete the e-mail and its attachments from all computers.</span></font><font color="#3b3b3b" face="Arial"
size="2"><spanstyle="font-size:10.0pt;font-family: 
Arial;color:#3B3B3B"></span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt"> </span></font></div>

Re: Users specific to a Database

От
Zdenek Kotala
Дата:
Sahoo, Ranjan Rashmi wrote:
> Hi All,
> 
>  
> 
>     I am new to this postgres and now struggling with creation of a user 
> specific to a database, so the user can login to that specific database 
> and can do the activities as per the given credentials and can not touch 
> or see any information from other databases. Can any one please help me 
> in this regard?
> 

Start there http://www.postgresql.org/docs/8.2/interactive/user-manag.html

And please, future question send to the general or novice mailing list. 
This list is focused on postgres development.
    Zdenek