Skip site navigation (1) Skip section navigation (2)

how to easily reduce permissions?

From: Robert Kleemann <robert(at)kleemann(dot)org>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: how to easily reduce permissions?
Date: 2001-09-03 03:28:38
Message-ID: Pine.LNX.4.33.0109022021100.16092-100000@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-novice
I'm learning sql and have several working databases on which I would like
to experment with various select statemenets.  The databases hold some
active data so I don't want to accidentally change anything.

Is there a way to easily connect to a database with read-only access or do
I have to create a new user, give that user read-only permission, and then
log in as that user?

thanx!
Robert


Responses

pgsql-novice by date

Next:From: Bo LorentsenDate: 2001-09-03 10:39:41
Subject: Insert rule and seqences
Previous:From: Mark Tessier and Martine VeilleuxDate: 2001-09-02 15:54:18
Subject: installing postgres on SunOS 5.7 as non-priviledged user

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group