- Original Message -
From: "bramhe manoj" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, September 28, 2005 3:54 PM
Subject: [ADMIN] database access queries
> hi ,
>
> we are working as linux administrators in enng college
> in mumbai(india).
>
> we have c
hi ,
we are working as linux administrators in enng college
in mumbai(india).
we have created databases in postgresql for all staffs
& students & granted them with permissions & password
query :
how to restrict database user from accessing other
users databases?
here we are getting problem
Hi,
I am new to PostgreSQL. I am running PostgreSQL on top of Cygwin on Windows
NT.
I am able to initialize the database cluster and create template1. I log in
and even create a 'test' table.
But querying it results in the error.
ERROR: pg_class_aclcheck: invalid user id 1730
Someone please help
Hi Tom,
> Did you remember to start the cygipc daemon?
Yes I did. It was not that. There is something broken with cygipc or the
way I used it. ;-)
I did a complete uninstall and a re-install (using the user id 'postgres')
and I am able to create databases!
Thanks!
Now I have one more hurdle
[EMAIL PROTECTED],
[EMAIL PROTECTED],
[EMAIL PROTECTED]
02/03/03 09:15 Subject: Re: [ADMIN] Database access
problem : SOS
[EMAIL PROTECTED] writes:
> There seems to be something wrong with the cygipc package! I keep getting
> this shmget() failure. I am pretty sure that there is enough memory on my
> system. The best part is sometimes after reinstalling everything, it
> sometimes works.
Did you remember to start the
[EMAIL PROTECTED] writes:
> ipc-daemon &
> initdb -D /usr/local/pgsql/data -U 1730 -W
> psql -U 1730 template1
If this is PG 7.3.*, there are some recently-identified problems with
using all-numeric usernames. Use a name instead of a number.
regards, tom lane
---
Hi,
I am new to PostgreSQL. I am running PostgreSQL on top of Cygwin on Windows
NT.
I am able to initialize the database cluster and create template1. I log in
and even create a 'test' table.
But querying it results in the error.
ERROR: pg_class_aclcheck: invalid user id 1730
Someone please hel
Hello all,
sorry about my english.
I use PostgreSQL-7.2.1 on Linux.
I have a problem to limit Database Access.
I want user X use (ONLY) database Y and user A use (ONLY) database B, and
so on.
Is there another way except use pg_ident.conf ? because i want more
restrictly from pg_ident.co
user1"
>as dba for database "db1", "user2" as dba for database "db2", and so on.
>How am I going to set this up in pg_hba.conf?
>
>Regards,
>Lau NH
>
>- Original Message -
>From: "omid omoomi" <[EMAIL PROTECTED]>
>
I going to set this up in pg_hba.conf?
Regards,
Lau NH
- Original Message -
From: "omid omoomi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, January 25, 2002 8:12 AM
Subject: Re: [ADMIN] Database access ri
Hi ,
Look at pg_hba.conf file usually under /usr/local/pgsql/data .
regards
Omid Omoomi
>From: "Lau NH" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: [ADMIN] Database access right
>Date: Fri, 25 Jan 2002 13:39:14 +0800
>
Hi ,
Look at pg_hba.conf file usually under /usr/local/pgsql/data .
regards
Omid Omoomi
>From: "Lau NH" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: [ADMIN] Database access right
>Date: Fri, 25 Jan 2002 13:39:14 +0800
>
Hi all,
Is there anyway to restrict the
database owner to access only to his/her database? because if I assign the
dba right to the database owner, he/she will be able to access other databases
in the same server. Is there anyway to restrict that?
Regards,Lau NH
At 09:36 PM 10/10/2001 , Tom Lane wrote:
>I will be exceedingly surprised if your 7.1.2 code let you into
>template0 either. Perhaps you are confusing it with template1?
My 7.1.2 on FreeBSD allows connections to template1 but not template0.
-crl
--
Chad R. Larson (CRL22)[EMAIL PROTE
Steve Frampton <[EMAIL PROTECTED]> writes:
> However, if I try to connect to template0, I get the following error
> message:
> psql: FATAL 1: Database "template0" is not currently accepting
> connections
Yup, that's what it's supposed to do.
I will be exceedingly surprised if your 7.1.2 code le
tup
you are not saving the output of postgres to a file so there is no way
to look at the log.
Ted
-Original Message-
From: Steve Frampton <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Date: Wed, 10 Oct 2001 04:42:19 -0400 (EDT)
Subject: [ADMIN] Database access error afte
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello:
I just moved a database server from 7.1.2 to 7.1.3. After looking in the
ChangeLog and not seeing anything that would seem to indicate any DB
structural changes, I did the upgrade as follows:
pg_ctl stop -D /home2/pgsql/data -w -m smart
mv /
I designing an SQL database and would like to base it on PostgreSQL. My
major concern is security, is there anything out there that details if
PostgreSQL has anything like database and/or table privileges. More
specifically, how-to set it up. I have looked all over the FAQ's and
HOW-TO pages and h
19 matches
Mail list logo
