On Tue, 25 May 1999, Jim Burnett wrote:
> Ok I am getting somewhere now,
>
> In access when I try to link a table I get an authentication failed. I
> tried to add a user using createuser, but i didnt pompt me for a
> password.
correct. You create a DB user not a Linux user.
> Also, do i need to add users to each database i make or just
> using the createuser in ./bin ?
you create all users that you need and If you do not use "grant" in the DB
every user can use any DBs.
su root
su postgres
createuser userz
yes, userz can create new user
yes, userz can create new DB
exit
exit
login like userz
createdb newDB
psql newDB
"Non � importante che tu sia crotalo o pavone, l'importante � che
se tu muori me lo dici prima". (C�lv)
--
Michel <ZioBudda> Morelli [EMAIL PROTECTED]
http://ziobudda.enter.it
Italian Linux FAQ http://ziobudda.enter.it/FAQ/
