Re: Call for port reports

--On Saturday, October 25, 2003 22:29:04 +0200 Peter Eisentraut
<peter_e(at)gmx(dot)net> wrote:

> Larry Rosenman writes:
>
>> *** ./expected/privileges.out Thu Oct 9 20:49:31 2003
>> --- ./results/privileges.out Sat Oct 25 12:04:45 2003
>> ***************
>> *** 247,253 ****
>> (1 row)
>>
>> CREATE FUNCTION testfunc3(int) RETURNS int AS 'select 2 * $1;' LANGUAGE
>> sql; -- fail
>> - ERROR: permission denied for language sql
>> SET SESSION AUTHORIZATION regressuser3;
>> SELECT testfunc1(5); -- fail
>> ERROR: permission denied for function testfunc1
>> --- 247,252 ----
>
> That sounds extremely strange. Can you step through the privileges.sql
> file manually (psql single-step mode) and check what the contents of
> pg_language, pg_shadow, current_user, and session_user are before the
> misbehaving command?
>
> --
> Peter Eisentraut peter_e(at)gmx(dot)net

here ya go:
Script started on Sat Oct 25 16:34:24 2003
$ psql -s reg? ?? ?? ?-U p? ?ler regression
Welcome to psql 7.4beta5, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

regression=# \i privileges.sql
***(Single step mode: verify
command)*******************************************
CREATE USER regressuser1;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:5: ERROR: user "regressuser1" already exists
***(Single step mode: verify
command)*******************************************
CREATE USER regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:6: ERROR: user "regressuser2" already exists
***(Single step mode: verify
command)*******************************************
CREATE USER regressuser3;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:7: ERROR: user "regressuser3" already exists
***(Single step mode: verify
command)*******************************************
CREATE USER regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:8: ERROR: user "regressuser4" already exists
***(Single step mode: verify
command)*******************************************
CREATE USER regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:9: ERROR: user "regressuser4" already exists
***(Single step mode: verify
command)*******************************************
CREATE GROUP regressgroup1;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:11: ERROR: group "regressgroup1" already exists
***(Single step mode: verify
command)*******************************************
CREATE GROUP regressgroup2 WITH USER regressuser1, regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:12: ERROR: group "regressgroup2" already exists
***(Single step mode: verify
command)*******************************************
ALTER GROUP regressgroup1 ADD USER regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

ALTER GROUP
***(Single step mode: verify
command)*******************************************
ALTER GROUP regressgroup2 ADD USER regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

ALTER GROUP
***(Single step mode: verify
command)*******************************************
ALTER GROUP regressgroup2 DROP USER regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

ALTER GROUP
***(Single step mode: verify
command)*******************************************
ALTER GROUP regressgroup2 ADD USER regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

ALTER GROUP
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser1;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
SELECT session_user, current_user;
***(press return to proceed or enter x and return to
cancel)********************

session_user | current_user
--------------+--------------
regressuser1 | regressuser1
(1 row)

***(Single step mode: verify
command)*******************************************
CREATE TABLE atest1 ( a int, b text );
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:26: ERROR: relation "atest1" already exists
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************

a | b
---+-----
1 | two
1 | two
(2 rows)

***(Single step mode: verify
command)*******************************************
INSERT INTO atest1 VALUES (1, 'one');
***(press return to proceed or enter x and return to
cancel)********************

INSERT 2356104 1
***(Single step mode: verify
command)*******************************************
DELETE FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************

DELETE 3
***(Single step mode: verify
command)*******************************************
UPDATE atest1 SET a = 1 WHERE b = 'blech';
***(press return to proceed or enter x and return to
cancel)********************

UPDATE 0
***(Single step mode: verify
command)*******************************************
LOCK atest1 IN ACCESS EXCLUSIVE MODE;
***(press return to proceed or enter x and return to
cancel)********************

LOCK TABLE
***(Single step mode: verify
command)*******************************************
REVOKE ALL ON atest1 FROM PUBLIC;
***(press return to proceed or enter x and return to
cancel)********************

REVOKE
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************

a | b
---+---
(0 rows)

***(Single step mode: verify
command)*******************************************
GRANT ALL ON atest1 TO regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
GRANT SELECT ON atest1 TO regressuser3, regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************

a | b
---+---
(0 rows)

***(Single step mode: verify
command)*******************************************
CREATE TABLE atest2 (col1 varchar(10), col2 boolean);
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:40: ERROR: relation "atest2" already exists
***(Single step mode: verify
command)*******************************************
GRANT SELECT ON atest2 TO regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
GRANT UPDATE ON atest2 TO regressuser3;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
GRANT INSERT ON atest2 TO regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
SELECT session_user, current_user;
***(press return to proceed or enter x and return to
cancel)********************

session_user | current_user
--------------+--------------
regressuser2 | regressuser2
(1 row)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************

a | b
---+---
(0 rows)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atest2;
***(press return to proceed or enter x and return to
cancel)********************

col1 | col2
------+------
bar | t
(1 row)

***(Single step mode: verify
command)*******************************************
INSERT INTO atest1 VALUES (2, 'two');
***(press return to proceed or enter x and return to
cancel)********************

INSERT 2356105 1
***(Single step mode: verify
command)*******************************************
INSERT INTO atest2 VALUES ('foo', true);
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:54: ERROR: permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
INSERT INTO atest1 SELECT 1, b FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************

INSERT 2356106 1
***(Single step mode: verify
command)*******************************************
UPDATE atest1 SET a = 1 WHERE a = 2;
***(press return to proceed or enter x and return to
cancel)********************

UPDATE 1
***(Single step mode: verify
command)*******************************************
UPDATE atest2 SET col2 = NOT col2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:57: ERROR: permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1 FOR UPDATE;
***(press return to proceed or enter x and return to
cancel)********************

a | b
---+-----
1 | two
1 | two
(2 rows)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atest2 FOR UPDATE;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:59: ERROR: permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
DELETE FROM atest2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:60: ERROR: permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
LOCK atest2 IN ACCESS EXCLUSIVE MODE;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:61: ERROR: permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
COPY atest2 FROM stdin;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:62: ERROR: permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
GRANT ALL ON atest1 TO PUBLIC;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:63: ERROR: permission denied for relation atest1
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1 WHERE ( b IN ( SELECT col1 FROM atest2 ) );
***(press return to proceed or enter x and return to
cancel)********************

a | b
---+---
(0 rows)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atest2 WHERE ( col1 IN ( SELECT b FROM atest1 ) );
***(press return to proceed or enter x and return to
cancel)********************

col1 | col2
------+------
(0 rows)

***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser3;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
SELECT session_user, current_user;
***(press return to proceed or enter x and return to
cancel)********************

session_user | current_user
--------------+--------------
regressuser3 | regressuser3
(1 row)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************

a | b
---+-----
1 | two
1 | two
(2 rows)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atest2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:74: ERROR: permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
INSERT INTO atest1 VALUES (2, 'two');
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:75: ERROR: permission denied for relation atest1
***(Single step mode: verify
command)*******************************************
INSERT INTO atest2 VALUES ('foo', true);
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:76: ERROR: permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
INSERT INTO atest1 SELECT 1, b FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:77: ERROR: permission denied for relation atest1
***(Single step mode: verify
command)*******************************************
UPDATE atest1 SET a = 1 WHERE a = 2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:78: ERROR: permission denied for relation atest1
***(Single step mode: verify
command)*******************************************
UPDATE atest2 SET col2 = NULL;
***(press return to proceed or enter x and return to
cancel)********************

UPDATE 1
***(Single step mode: verify
command)*******************************************
UPDATE atest2 SET col2 = NOT col2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:80: ERROR: permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
UPDATE atest2 SET col2 = true WHERE atest1.a = 5;
***(press return to proceed or enter x and return to
cancel)********************

UPDATE 0
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1 FOR UPDATE;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:82: ERROR: permission denied for relation atest1
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest2 FOR UPDATE;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:83: ERROR: permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
DELETE FROM atest2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:84: ERROR: permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
LOCK atest2 IN ACCESS EXCLUSIVE MODE;
***(press return to proceed or enter x and return to
cancel)********************

LOCK TABLE
***(Single step mode: verify
command)*******************************************
COPY atest2 FROM stdin;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:86: ERROR: permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1 WHERE ( b IN ( SELECT col1 FROM atest2 ) );
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:89: ERROR: permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest2 WHERE ( col1 IN ( SELECT b FROM atest1 ) );
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:90: ERROR: permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
COPY atest2 FROM stdin;
***(press return to proceed or enter x and return to
cancel)********************

***(Single step mode: verify
command)*******************************************
SELECT * FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************

a | b
---+-----
1 | two
1 | two
(2 rows)

***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser3;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
CREATE TABLE atest3 (one int, two int, three int);
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:102: ERROR: relation "atest3" already exists
***(Single step mode: verify
command)*******************************************
GRANT DELETE ON atest3 TO GROUP regressgroup2;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser1;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
SELECT * FROM atest3;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:107: ERROR: permission denied for relation atest3
***(Single step mode: verify
command)*******************************************
DELETE FROM atest3;
***(press return to proceed or enter x and return to
cancel)********************

DELETE 0
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser3;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
CREATE VIEW atestv1 AS SELECT * FROM atest1;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:115: ERROR: relation "atestv1" already exists
***(Single step mode: verify
command)*******************************************
/* The next *should* fail, but it's not implemented that way yet. */
CREATE VIEW atestv2 AS SELECT * FROM atest2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:117: ERROR: relation "atestv2" already exists
***(Single step mode: verify
command)*******************************************
CREATE VIEW atestv3 AS SELECT * FROM atest3;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:118: ERROR: relation "atestv3" already exists
***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv1;
***(press return to proceed or enter x and return to
cancel)********************

a | b
---+-----
1 | two
1 | two
(2 rows)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:121: ERROR: permission denied for relation atest2
***(Single step mode: verify
command)*******************************************
GRANT SELECT ON atestv1, atestv3 TO regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
GRANT SELECT ON atestv2 TO regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv1;
***(press return to proceed or enter x and return to
cancel)********************

a | b
---+-----
1 | two
1 | two
(2 rows)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:128: ERROR: permission denied for relation atestv2
***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv3;
***(press return to proceed or enter x and return to
cancel)********************

one | two | three
-----+-----+-------
(0 rows)

***(Single step mode: verify
command)*******************************************
CREATE VIEW atestv4 AS SELECT * FROM atestv3;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:131: ERROR: relation "atestv4" already exists
***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv4;
***(press return to proceed or enter x and return to
cancel)********************

one | two | three
-----+-----+-------
(0 rows)

***(Single step mode: verify
command)*******************************************
GRANT SELECT ON atestv4 TO regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv3;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:139: ERROR: permission denied for relation atestv3
***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv4;
***(press return to proceed or enter x and return to
cancel)********************

one | two | three
-----+-----+-------
(0 rows)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atest2;
***(press return to proceed or enter x and return to
cancel)********************

col1 | col2
------+------
bar |
bar | t
(2 rows)

***(Single step mode: verify
command)*******************************************
SELECT * FROM atestv2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:143: ERROR: permission denied for relation atest2
You are now connected to database "regression".
***(Single step mode: verify
command)*******************************************
REVOKE ALL PRIVILEGES ON LANGUAGE sql FROM PUBLIC;
***(press return to proceed or enter x and return to
cancel)********************

REVOKE
***(Single step mode: verify
command)*******************************************
GRANT USAGE ON LANGUAGE sql TO regressuser1;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
GRANT USAGE ON LANGUAGE c TO PUBLIC;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:153: ERROR: language "c" is not trusted
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser1;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
GRANT USAGE ON LANGUAGE sql TO regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:156: ERROR: permission denied for language sql
***(Single step mode: verify
command)*******************************************
CREATE FUNCTION testfunc1(int) RETURNS int AS 'select 2 * $1;' LANGUAGE sql;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:157: ERROR: function "testfunc1" already exists with
same argument types
***(Single step mode: verify
command)*******************************************
CREATE FUNCTION testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:158: ERROR: function "testfunc2" already exists with
same argument types
***(Single step mode: verify
command)*******************************************
REVOKE ALL ON FUNCTION testfunc1(int), testfunc2(int) FROM PUBLIC;
***(press return to proceed or enter x and return to
cancel)********************

REVOKE
***(Single step mode: verify
command)*******************************************
GRANT EXECUTE ON FUNCTION testfunc1(int), testfunc2(int) TO regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
GRANT USAGE ON FUNCTION testfunc1(int) TO regressuser3;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:162: ERROR: invalid privilege type USAGE for function
***(Single step mode: verify
command)*******************************************
GRANT ALL PRIVILEGES ON FUNCTION testfunc1(int) TO regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
GRANT ALL PRIVILEGES ON FUNCTION testfunc_nosuch(int) TO regressuser4;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:164: ERROR: function testfunc_nosuch(integer) does not
exist
***(Single step mode: verify
command)*******************************************
CREATE FUNCTION testfunc4(boolean) RETURNS text
AS 'select col1 from atest2 where col2 = $1;'
LANGUAGE sql SECURITY DEFINER;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:168: ERROR: function "testfunc4" already exists with
same argument types
***(Single step mode: verify
command)*******************************************
GRANT EXECUTE ON FUNCTION testfunc4(boolean) TO regressuser3;
***(press return to proceed or enter x and return to
cancel)********************

GRANT
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser2;
***(press return to proceed or enter x and return to
cancel)********************

SET
***(Single step mode: verify
command)*******************************************
SELECT testfunc1(5), testfunc2(5);
***(press return to proceed or enter x and return to
cancel)********************

testfunc1 | testfunc2
-----------+-----------
10 | 15
(1 row)

***(Single step mode: verify
command)*******************************************
CREATE FUNCTION testfunc3(int) RETURNS int AS 'select 2 * $1;' LANGUAGE sql;
***(press return to proceed or enter x and return to
cancel)********************

psql:privileges.sql:173: ERROR: function "testfunc3" already exists with
same argument types
***(Single step mode: verify
command)*******************************************
SET SESSION AUTHORIZATION regressuser3;
***(press return to proceed or enter x and return to
cancel)********************
x
***(Single step mode: verify
command)*******************************************
SELECT testfunc1(5);
***(press return to proceed or enter x and return to
cancel)********************
regression=> select? ?? ?? ?? ?? ?? ????\?~d? ?? ?d? ?c regression ler
You are now connected to database "regression" as user "ler".
regression=# select * from pg_language;
***(Single step mode: verify
command)*******************************************
select * from pg_language;
***(press return to proceed or enter x and return to
cancel)********************

lanname | lanispl | lanpltrusted | lanplcallfoid | lanvalidator |
lanacl
----------+---------+--------------+---------------+--------------+--------
--------------------------
internal | f | f | 0 | 2246 |
c | f | f | 0 | 2247 |
plpgsql | t | t | 2218642 | 0 |
sql | f | t | 0 | 2248 |
{=U/postgres,regressuser1=U/ler}
(4 rows)

regression=# select * from pg_shadow;
***(Single step mode: verify
command)*******************************************
select * from pg_shadow;
***(press return to proceed or enter x and return to
cancel)********************

usename | usesysid | usecreatedb | usesuper | usecatupd |
passwd | valuntil | useconfig
--------------+----------+-------------+----------+-----------+------------
-------------------------+----------+-----------
horde | 407 | t | f | f |
md5789761213b76339cb1da715d0c51d888 | |
ler | 101 | t | t | t |
md5dc936a84fbec3cdca4209c15f1ce424d | |
mrm | 401 | t | f | f |
md59a6f9a2291c2b99dfa7794167f6f90e5 | |
cph | 151 | t | f | f |
md56f213a50183cb0b5b503391c96061751 | |
nobody | 403 | f | f | f |
md5eaa50fc990ef9147accb04fd39c69263 | |
ed | 402 | t | f | f |
md56d10f55bec241097be543d50441902a4 | |
webmail | 404 | t | f | f |
md5939853e11c511400d5709c547287a8a9 | |
tipnet | 405 | t | f | f |
md5ceba6024d54ca3d68647dae1cd58222a | |
nagios | 408 | f | f | f |
md5d36bbc9979deee7cca850e582b9a8e18 | |
webcal | 409 | f | f | f |
md5e736e686ce964baaa81ec18583f06921 | |
bric | 413 | f | f | f |
md55a71606fd33d3e92229ce73ad6c3f408 | |
ohp | 410 | t | f | f |
md59276c229c3c21fdc944a7532db499a01 | |
root | 411 | t | t | t |
md5a54504778e2f7c06d13e420bca278b16 | |
rt_user | 412 | f | f | f |
md5e5ffbd5626278386cfa50d801ce24517 | |
regressuser1 | 414 | f | f | f |
| |
postgres | 1 | t | t | t |
md51a4c61baf99fb9be1b8763c70f4304e7 | |
regressuser2 | 415 | f | f | f |
| |
regressuser3 | 416 | f | f | f |
| |
regressuser4 | 417 | f | f | f |
| |
(19 rows)

regression=# select *? ?current_user session_user;???????????????[1@,
***(Single step mode: verify
command)*******************************************
select current_user, session_user;
***(press return to proceed or enter x and return to
cancel)********************

current_user | session_user
--------------+--------------
ler | ler
(1 row)

regression=# \q
$

script done on Sat Oct 25 16:36:56 2003

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749