User/login questions

Поиск
Список
Период
Сортировка
Искать
От
Jason Hihn
Тема
User/login questions
Дата
Msg-id
NGBBLHANMLKMHPDGJGAPCEGDCMAA.jhihn@paytimepayroll.com
Список
Дерево обсуждения
User/login questions Jason Hihn <jhihn@paytimepayroll.com>
Re: User/login questions Tom Lane <tgl@sss.pgh.pa.us>
Re: User/login questions Jason Hihn <jhihn@paytimepayroll.com>
Re: User/login questions Tom Lane <tgl@sss.pgh.pa.us>
I wish to implement a web-based login system where the user logs in and gets
a list of available databases. This involves several things that I have
questions on:
1) Connecting to the DB and logging in (Must the user connect to a
database?)
2) Finding out what databases the user has access to (How?) without having
to maintain a copy myself. (Can it be pulled from some system table, or join
of system tables? (i.e. SELECT db_name FROM something WHERE user='me' AND
granted_perm='SELECT')

Also, I'm stuck in 7.2 land, with a planned upgrade to 7.4, when it comes
out.


Thanks!

Jason Hihn
Paytime Payroll


В списке pgsql-novice по дате отправления
От: Stephan Szabo
Дата:
Сообщение: Re: pqgetresultset problem
От: Jason Hihn
Дата:
Сообщение: Fast deletes
FAQ