On Tue, 27 Sep 2011, Matt Abernathy wrote:
Here is my confusion. Is the 'admin' Owner the database owner or is that
the superuser on the system? ie. Is admin=root, or is admin the actual
database owner?
Matt,
The database owner is 'admin'. That means you (as a user) might have
limited access to those databases but you don't control them.
Here is what I have:
[rshepard@salmo ~]$ psql -l
List of databases
Name | Owner | Encoding | Collation | Ctype | Access
privileges
-----------+------------+-----------+-----------+-------+-----------------------
aesi | sql-ledger | SQL_ASCII | C | C |
cms | rshepard | SQL_ASCII | C | C |
jerritt | rshepard | SQL_ASCII | C | C |
jerrittwq | rshepard | SQL_ASCII | C | C |
nevada | rshepard | SQL_ASCII | C | C |
postgres | postgres | SQL_ASCII | C | C |
refdb | postgres | SQL_ASCII | C | C |
scirefs | rshepard | SQL_ASCII | C | C |
plus the system templates.
Rich
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
