Hi, how can I grant privileges with grant option since
PostgreSQL does not support statement:
GRANT WITH GRANT OPTION;
if this is done by default then how can I grant
privileges without grant option?
Rumen
__
Do You Yahoo!?
Send instant messag
hi there,I'm migrating from MySQL to PgSQL and
I have few questions on PgSQL securiry:
1. How can I forbid to some users to create tables
in some databases which they can acccess.
2. How can I GRANT/REJECT some privileges on all
objects in a database TO/FROM some users, since i
can't type "GRA
ot integrated in
the system databases of pgSQL,like in MySQL for
example?
3.Are there any plans in making security system more
flexible?
regards:
Rumen
--- Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> R D writes:
>
> > 1. How can I forbid to some users to create
> ta
Hi,
> > 2.Why the authentication system is not integrated
> in
> > the system databases of pgSQL,like in MySQL for
> > example?
>
> Because there's a bootstrapping problem: You would
> have to connect to the
> database to change the authentication settings, but
> in order to connect
> you have
--- Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Chris Albertson writes:
>
> > > > 2.Why the authentication system is not
> integrated in
> > > > the system databases of pgSQL,like in MySQL
> for
> > > > example?
> > >
> > > Because there's a bootstrapping problem: You
> would have to connect
Hi everybody!
I saw in the pgSQL 7.0.1 release notes that pg_dump
handles OID indexes, does it mean that new pg_dump is
able to dump large objects?
regards,
Rumen
__
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
http://photos.yahoo.com
Hi there,
i have few questions in users and droups in pgSQL that
i can't check in the next few days and this is
inportant in my choice of database:
1. If I'm using different password files for each
database can I grant or revoke privileges to this
users without creating the same users in pg_user
--- Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> R D writes:
>
> > 1. If I'm using different password files for
> each
> > database can I grant or revoke privileges to this
> > users without creating the same users in pg_user
> > table?
>
&g
--- Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> On Mon, 19 Jun 2000, R D wrote:
>
> > Hi,I need a secondary passwd files because I do
> not
> > know another way to manage user access to DBs.
>
> That's what I thought.
>
> > If there was a pg
--- Stefan Muehlebach <[EMAIL PROTECTED]>
wrote:
> Hi there
>
> How can I prevent a user from creating a table in a
> database that she is
> not owner of?
>
You can't. But as far as I know it's worked on the
problem.
Rumen
p.s. Sorry if message is doubled but there was no
responce from pgsql-
--- Denis Pugnere <[EMAIL PROTECTED]> wrote:
>
> PG 7.0.2, RH Linux 6.2
>
> I'm trying to secure access to pgsql databases.
> the politic I use is to only allow access databases
> with passwords.
>
> for this, I use in pg_hba.conf :
> local all password
> host
Hi,
In the TODO list is mentioned that in PG-7.1 you will
have "More access control over who can create tables
and use locks".
Does anybody know what concept will be used? Will it
be done via GRANT and REVOKE?
regards,
Rumen
__
Do You Yahoo!?
Get Y
Hi,
I'm making a database with table of over 50 000 000 i
created index on some columns but they are used only
in range search (e.g. WHERE column<100 AND column>10)
and point rearch (e.g. WHERE column=100). When I try
to execute some queries using only <,>,<= or >= index
is not used.
So is the
Hi,
I have some problems with postgresql 7.0.3 running on
Slackware linux 7.1.
I have a table with about 25 milion records:
create table gsc_act(reg_id int2,id int2,ra int4, de
int4,mag int2);
i created 2 indexes:
create index gsc_act_de on gsc_act(de);
create index gsc_act_rd on gsc_act(de,r
Hi,
I run postgresql 7.0.3.
I have a large table and i started to create an index
on it. Unfortunately the diak space was not enough and
got a message that the device was full. From this
moment the table i tried to index has 0 rows. what is
wrong? I tried ipcclean, postgres reboot, system
reboot a
No, plain select also does not work.
--- Stephan Szabo <[EMAIL PROTECTED]>
wrote:
>
> Hmm, does a plain select * from gsc_act work?
> Also, what does explain show for the queries?
>
> Stephan Szabo
> [EMAIL PROTECTED]
>
> On Thu, 21 Dec 2000, R D wrote:
>
--- Stephan Szabo <[EMAIL PROTECTED]>
wrote:
>
> Does dropping and recreating the index help?
10x! It worked!
Rumen
__
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/
I hoped to see that and per database allow/deny
ctreation of tables to groups/users in PostgreSQL 7.1
but as far as I know it will not be done.
Rumen
--- [EMAIL PROTECTED] wrote:
> I've been searching the lists and found a similar
> question but there have no
> replies.
>
> What I would like t
--- Kevin Schachter <[EMAIL PROTECTED]> wrote:
> I recently installed Postgres on my server to rid of
> the horrible
> limitations of Mysql. However I am having some
> trouble setting up
> permissions as they are in MySQL.
>
> In MySQL you can grant a user select permissions to
> all tables in a
--- Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> R D writes:
>
> > This is one of the features of PgSQL that I do not
> > like. It is much nicer to type:
> > "grant all on database.table to ."
> > And I asked the developers to do that but they
Hi,
yes it's true, but it's not so serious. Me and many
other people are working with postgreSQL and never
felt this limit. So if you want to insert some large
data in a row, for example picture, you should use
Large Objects (See the manuals).
And now the good news: the upcomming PostgreSQL 7.1
I would like to see some restrictions on who can or
who can not create things in a database too.
Hoping too see this soon
Rumen
--- Markus Wigge <[EMAIL PROTECTED]> wrote:
> Hi PG-Admins,
>
> I think this question is asked more often than
> you'd like it to be
> so excuse me ...
> Is
Hi,
I discivered some strange behaviour in GRANT. When I
CREATE a table and GRANT some privilege to some user
this privilege is REVOKEd from me ?!? So I have to
GRANT the same to me afterwards. Once I have GRANTed
this privilege to myself I can GRANT it to whoever I
want without REVOKE-ing it from
Hi,
The FAQ says:
_
4.6) What is the maximum size for a row, table,
database?
These are the limits:
Maximum size for a database?
unlimited (60GB databases exist)
Maximum size for a table?
Hi,
PostgreSQL has this limitation. The max row size is
8K.
You can recompile Postgres with max row size of 32K
(not more). This limitation is removed in PgSQL 7.1
which is not released yet. It's in beta phase.
regards,
Rumen
--- Bogdan Paduraru <[EMAIL PROTECTED]> wrote:
> Hello folks,
>
> I h
I think it will do.
I'm developing a web system based on PgSQL. My test
server is Cyrix 166MHz 16MB of RAM. My database has
few tables with over 1 milion rows and one of them has
almost 25 milions. With good indexes I can fetch data
form this table for less than 8-10 seconds.
But it depends on the
Hi guys,
I would like to know somethimg more specific for
indexes and clusters as far as I do not know very much
of R-TREES.
I have this situation:
create table gsc_act(
reg_id int2,
id int2,
ra int4,
de int4,
mag int2
);
This is a huge table approx 2GB cont
Hi PostgreSQL folks,
I would like to know is there any way to use indexes
with the views or rules in this situation:
cteate table test1(col1 int,col2 int,col3 int);
insert into test1 .;
..
insert into test1 .;
create index test1_col1_col2 on test1(col1,col2);
create view t
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> R D <[EMAIL PROTECTED]> writes:
> > i'm storing col1 to col3 as integers to save
> storage
> > space(infact they are fixed point).I have many
> tables
> > ctrated using this template only the view devidor
>
Unfortunately There is no way atleast i do not know of
such since you can not REVOKE this from users. I do
not know why The developers consider this as not so
inportant. This capability was in the todo list for
7.1 but was removed. I would like to see this feature
in postgres because I'm tyred dro
Hi,
I'have been waiting for a long time for control on who
can and who can not create tables. I'm plannig to
migrate all my DBs from MySQL to PostgreSQL (I have
already done this where possible) but it's inpossibe
now since now it's inpossible to deny table creation
to some users. I hoped that 7.
31 matches
Mail list logo
