[INIMSS] problem with user privileges

Поиск
Список
Период
Сортировка
От Dino
Тема [INIMSS] problem with user privileges
Дата
Msg-id 02052100065800.03618@yappee.co.in
обсуждение исходный текст
Список pgsql-sql
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



В списке pgsql-sql по дате отправления:

Предыдущее
От: Eckhard Hoeffner
Дата:
Сообщение: Re: Using LASTOID in one query
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: A proposal for Interval Math