Thanks Rich. So in your case, for the nevada database, would you add a user, set the database as nevada and db user as rshepard?
On Tue, Sep 27, 2011 at 5:15 PM, Rich Shepard <[email protected]> wrote: > 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 > _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
