From: Dino <dino@initl.net>
To: pgsql-sql@postgresql.org
Subject: [INIMSS] problem with user privileges
Date: Tue, 21 May 2002 00:06:57 +0530
Message-ID: <02052100065800.03618@yappee.co.in> (raw)
Hi,
I am trying with the user privileges in postgresql-7.1.3-1PGDG on RedHat 7.1 .
I followeb this procedure;
foo$ psql template1 postgres
template1=# create user dba with createdb createuser;
template1=# \q
foo$ psql template1 dba
template1=# create database mydb;
template1=# \q
foo$ psql mydb dba
mydb=# create table table_a (id int primary key, name char(10));
mydb=# create user dbu1;
mydb=# grant select,insert on table_a to dbu1;
Up to this all are working as expected. The user dbu1 can make only SELECT
and INSERT on table_a.
Then I added one more user (dbu2) using the command at psql prompt.
mydb=# create user dbu2;
When connected to the DataBase mydb as dbu2, the user cannot create database
on perform operations on table_a, but can create new tables and he has full
control over it.
Is there any way to prevent such a situation by revoking the permissions of
the user dbu2 on the database, so that he will not be able to connect to the
database?
Thank You
Dino
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dino@initl.net
Subject: Re: [INIMSS] problem with user privileges
In-Reply-To: <02052100065800.03618@yappee.co.in>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox