Kalai R wrote:
> i am near to PostgreSql. I create a database by the
> superuser. Then i create another logon user. Now how can i
> protect my database from the new user. i want to ban the
> access and view the database to the new user.It can done by
> an entry in pg_hba file. Is there any oth
hi,
i am near to PostgreSql. I create a database by the superuser. Then i create
another logon user. Now how can i protect my database from the new user. i
want to ban the access and view the database to the new user.It can done by
an entry in pg_hba file. Is there any other way to secure my datab
hi,
i am near to PostgreSql. I create a database by the superuser. Then i create
another logon user. Now how can i protect my database from the new user. i
want to ban the access and view the database to the new user.It can done by
an entry in pg_hba file. Is there any other way to secure my datab
Look at changing your pg_hba.conf file
If you have a line in the file like:
hostall all 127.0.0.1/32 trust
change it to:
hostall all 127.0.0.1/32 md5
then run:
pg_ctl reload
should get you whare you want to be.
Ben
"Danilo Freitas da Co
On 23/05/2007 21:31, Danilo Freitas da Costa wrote:
How can I configure access level to a database? How can I force every
user type your password to access the database?
http://www.postgresql.org/docs/8.2/static/client-authentication.html
Ray.
Hi all!!!
I'm using Postgres at company I work for few time.
I already tried many ways to create a security for my database but not
sucessfull.
The postgres was installed with default configuration and I had definied
"postgres" as root user.
However, someone else user I create have full access
Michael Trausch <[EMAIL PROTECTED]> writes:
> I'd like to know if I can constrict database and data access
> on a row-level with PgSQL by using some sort of trickery in the database
> configuration itself.
You could do this with views, on the order of
create view secure_view as
se
Hello everyone,
I'm working with an application, and I'm realizing that perhaps the
model for security that I have used in the past won't work all that well
with the application that I'm working on. I am certain that this
particular model is how web applications traditionally work, but I am
wonde
