--On Saturday, October 25, 2003 22:29:04 +0200 Peter Eisentraut <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]
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 quitregression=# \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: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
pgp00000.pgp
Description: PGP signature
